Hi!

The easiest way if you use the default sheet names Sheet1,
Sheet2 .... Sheet125

=SUM(Sheet1:Sheet125!A1)

If you use custom sheet names:

Insert a new sheet before the first sheet and name it
START. Insert another new sheet after the last sheet and
name it END.

=SUM(Start:End!A1)

If you will need to create any new sheets that should also
be used in this calculation just insert them between START
and END.

Biff

-----Original Message-----
how do I sum the same cell from multiple worksheets? In
this case I will have
about 125 worksheets in the workbook so I'm looking for a
shortcut. Thanks
.