I have a spreadsheet that will eventually contain 52 sheets(one for each week) On each sheet there is a cell with a percentage in it. I would like to copy this cell to a summary sheet so that it can be graphed.

The formula on the summary sheet is `=Week1!J7`

. Copying the data from cell `J7`

in sheet `week 1`

. Is there a way to autofill this formula but increase the sheet number? eg `=Week2!J7`

.