Don't know if I quite understand what you mean, but does something like this
help:

=AVERAGE(Sheet1:Sheet5!A1:A5)

=SUM(Sheet25:Sheet100!A1:A5)

?
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"DB" wrote in message
...
I know there is a way to select arrays on different sheets one array at a
time. Is there is a way to select arrays (located in the exact same cell
range) on different sheets collectively? I'm trying to set up a template
and
only need to doe this once but there will be in excess of 100 sheet tabs.

Thanks for your help.

DB