You have 51 worksheets and you want the sum of the the
same cell. Let's say the cell is a1.

=sum(sheet1:sheet51!a1)

-----Original Message-----
I am trying to simplify a formula on a worksheet that
sums the same cell on 50 other worksheets all within the
same workbook. I can do it the long way of inputing
the "worksheet"!cell for each worksheet but isn't there a
shortcut for doing this?

Thank-you and if you reply by e-mail that would be a help.
.