Assuming that the sheets are all of a standard format, the usual way is to
add a sheet at the start of them, say called 'First' and another at the end,
before your summary sheet, called say 'Last', and then use

=SUM(First:Last!A1)

The First and Lasst sheets can be hidden to avoid confusion.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Carolina Girl" wrote in message
...
I have a an excel file (Microsoft Excel 2003 version) that contains several
sheets. How do I create a new sheet with totals gathered from existing
sheets within the same excel file.
--
Carolina Girl