Hi there,
Perhaps someone can help me with this issue, it's a bit long so bear with me.
I have 2 spreadsheets, the first one is called data, the second one is
called summary
On the data sheet, I have it lay out as a sample like below, in different
columns, all in text format

week 1 Jan 1 Jan 2 Jan 3 Jan 4
week 2 Jan 8 Jan 9 Jan 10 Jan 11
week 3 Jan 17 Jan 18 Jan 19

On the summary sheet, I'd like to have a drop down menu on cell A1 that
should have the week number as my choices, and then as I select the week
number, the date will show up on a set of cells and change accordingly as I
select a different week on the drop down menu.

Thanks for all your help