Oh, I forgot: Is there also a way i can tell the formula to link to a
specific number tab in a workbook (ie, always look to the fifth sheet in the
workbook, no matter what the name of that sheet actually is)--or will the
formula update the sheet reference name when the tabbed display is changed
(for instance 4/1 to 5/1)?

"ScottyC" wrote:

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?