Hi

I am not sure I am go to explain this correctly, but I will try my best.

I have a workbook with a number of worksheets called week 1, week 2 up to
week 52.

I then have a summary sheet that is used to summarise data from the various
weeks. In the summary worksheet I have a column listing the weeks

ie
B
5 Week 1
6 Week 2
7 Week 3
etc

and what I would like to do is use the name of the week to link to the
worksheets rather then using say ='Week 2'!T$27 as I have approx 50 cells
that I summarise the day and would like to make adding of a new week a
little easier.

I hope I have explained this OK and appreciated any suggestions.

Cheers
Andrew