If the sheets has consecutive names you could use =SUM(Sheet2:Sheet3!G53)
But you have 'odd' sheet names.
Insert a new worksheet before J.Bloogs and rename it "Start" - no quotes
Insert a worksheet after Z.Zwickernan (your last one) and name in "End"
Now use =SUM(Start:End!G53)
If you use names with spaces you will need single quotes in the formula
=SUM('My First Sheet:My Last Sheet'!G53)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Hazel" wrote in message
...
Hi All

In the same cell G53 on each sheet in a 50 sheet workbook - I need to add
them all together in Sheet1 - say in cell A100, at the moment I'm using
the
following -- there has to be an easier way than entering

=J.Bloggs!G53+J.Smith!G53 etc --


--
Many thanks

hazel