Ok here's the deal (please bare with me):

I have a workbook that is 52 sheets long. Each sheet represents weeks 1 to 52. There is a block in each sheet that needs to feed off the prior sheets same block but add 1 to it. What is the formula to do this AND how do I copy this to all 52 sheets in one fell swoop? The block represents the week number, so on spreadsheet 2, the formula should reference week one and add one. On spreadsheet 3, the block should reference spreadsheet 2 and add one. Is there any way to do this?

Please Help!

Thanks

Sadric