Assuming your formula is in row 1:
INDIRECT("Sheet"&ROW()&"!A1:A7")

you can copy down

HTH
--
AP

"ScottyC" a écrit dans le message de
...
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?