Drag-filling sheet numbers

[BigDanz]

Hello,

There's a sheet for each week of the year in my workbook. They're named
week-1, week-2 and so on untill week-52. In another sheet I have lots of references to all the 52 sheets. Is there a way to drag-fill and increment the week numbers?

example:

='week-1'!$A$2
='week-2'!$A$2
='week-3'!$A$2

Thank you for any help,

Dan.

[Domenic]

Enter the following formula in a cell and copy down:

=INDIRECT("'week-"&ROW(A1)&"'!A2")

Hope this helps!

[BigDanz]

Thanks a lot Domenic!

Your solution is working perfectly...

Dan.