I am running a spreadsheet for a college we have a summary page that shows
the weeks total applications divided by the number accepted. What i would
like to do is have that cell automatically reference the next weeks figures.

For example say that the figures we require for week 1 are in row 1 columns
A1 to A5 and week two are in A6 to A10. My summary page would link to cells
A1 to A5 to show them there. What I would like to be able to do is that in
week two the summary page cells automatically link to cells A6 to A10 to now
show these figures instead of A1 to A5. Is this possible???