You can use cell references. For example...

=Sheet1!A1

then you can drag it down / across as per the need.


"JCreationBoy" wrote in message
...
My thing is I have lets say 5 worksheets all under one file name. Each
sheet
contains money totals for one particular area. I then have another sheet
that
contains all of the totals from the other four sheets and the overall
total.
What I have been doing is taking each total from each sheet and copying
and
pasting. Is there a formula that you can use to do that automatically? I
am
useing Excell 2003.