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