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.