Drop Down List Query

[Rawdinae]

Hi I am just learning Excel trying to setup a spreadsheet - my query is how do you set up a drop down list which contains variable information - linked to another spreadsheet where the information is input.

I want to be able to change list using week numbers which return a set of varible data for that week.

Can anyone advise best way to tackle this?

Thanks