Copying a formula relating to different sheets...

Hi all,

I have a formula on a spreadsheet: ='1'!$r$11

This formula is on my summary sheet where it picks up a figure on a sheet entitled 1 in the same workbook. I have 52 sheets in this workbook and my summary sheet needs to pick up the same cell reference in each of the 52 sheets.

Is there any way to copy this formula across my 52 columns where it will automatically plus 1 to the sheet number in this formula rather than me altering every formula manually? (I'm using 2007)

Thanks,

Hmm,

I tried that but it didn't seem to work, I've attached the spreadsheet.

It's lines 5, 6, 26m 27 & 28 I'm looking for a fast fix for.

Thanks,

Cheers,

Thanks.