Thanks for the help, the replies I received have help[ed a great deal.

"Joel" wrote:

If your formula has


Week 10 Sht!A1:A100

If row 1 contain the week number then

Indirect("Week " & C1 & " Sht!A1:A100")


"Mike B" wrote:

,Can anyone help!

I have a workbook containing worksheets representing each week of the
year,numbered 1 - 52, there is also a worksheet on which I collect data.

I need to populate cells on the Data worksheet with infromation from the
worksheet relating to the current week of the year. I can get HLOOKUP to work
but only if I enter the Sheet number in the fomula. How dow I write the
formula to look up the correct worksheet , based on the Number I enter into
the Week Number cell on my Data worksheet