I am looking for a way for my formula to reference the same group of cells on
each page, but the sheet name needs to be able to roll when it is pasted (so
I don't have to keep editing it). for example:

sheet1 A1:A7
sheet2 A1:A7
sheet3 A1:A7

and so on.

Can anyone help?