Say I have week ones figures in cells in row 1 columns A1 to A5 and week two
figures in columns A6 to A10.
I have a summary page that links to cells A1 to A5 to show them there. Would
it be possible then in week two for the summary page to automatically update
the reference cells to show cells A6 to A10 instead of A1 to A5?
Basically is there any time based function or macro that could do this?