Hi!

One way:

Insert a blank worksheet and move it so that it is the first tab** and name
it START.
Insert another blank worksheet and move it so that it is the last tab and
name it END.

Then your formula would be:

=SUM(Start:End!Z100)

Any sheet that's inserted or moved and is between START and END will be
included in the formula.

If your formula is on Sheet1 and you don't want Sheet1 to be included in
this calculation then move the START sheet to the immediate right of sheet1.
(so that it's the 2nd tab and Sheet1 is the 1st tab).

Biff

"Triptanes" wrote
in message ...

In cell A5on Sheet1, place a formula or function that will add the
contents of cell Z100 on all the sheets.

How?




--
Triptanes
------------------------------------------------------------------------
Triptanes's Profile:
http://www.excelforum.com/member.php...o&userid=33849
View this thread: http://www.excelforum.com/showthread...hreadid=536268