Rob -

The problem is that there is no "between" involved. It's always the
second tab, and every quarter it has a new name. To invent some syntax,
I'd want something like

A1: = sheet[+1]!A1

from RC notation.

....best, Hash


In article ,
"Rob" wrote:

Hash,

If the following was the formula in say cell A1 of Sheet1 (your summary),
then inserting a new sheet between Sheet2 and Sheet3 would automatically be
included in the summary sheet (Sheet1).

=SUM(Sheet2:Sheet3!A1)

Regards, Rob

wrote in message
...
Gang -

I have a workbook with a summary worksheet at the first tab, and then a
new worksheet inserted every quarter as the second tab. Earlier quarters
are pushed to the right on the tabs.

Is there a way to reference data on the second tab no matter what that
second worksheet is titled? It changes every quarter. Right now I do a
global replace manually via menu.


Thanks in advance.

...best, Hash