Auto increment a value across multiple worksheets

[Ted Dennis]

I have a "payslip" spread sheet which has 2 "master lookup" sheets and 52 sheets named Week 1 through to Week 52.

I am using the 2 lookup sheets to pull through various details to each "payslip (week 1 to 52).

On each payslip sheet cell A1 states the week number. Is there a formula I can paste into the one sheet that when I copy 52 (making 52 sheets) will automatically increment this value in line with the sheet name 1,2,3,4 etc

Hope this makes sense

Any help would be appreciated

Thanks

Ted

[LokeshKumar]

Could you please upload the sample workbook.....