Let XL make the formula for you.

Click in the cell that is to display the total, and enter an equal sign,
=
then, click in the cell containing the first value,
Then hit the plus sign
+
Now, click on the Sheet5 tab, and click in the cell containing the second
value,
And then hit <Enter.

You now have the syntax that you can duplicate for your other totals, or,
you can continue creating your formulas in the same manner that you did the
first one.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"bustanutti21"
wrote in message
news:bustanutti21.20icjy_1135366201.0555@excelforu m-nospam.com...

Hi there.. I have a report that i need to create.. I have a file that
has 5 worksheets and i need to add a cell from sheet one to a cell in
sheet 5... I'm sure this is simple but i cant figure out how to add
from multiple worksheets

thanks


--
bustanutti21
------------------------------------------------------------------------
bustanutti21's Profile:
http://www.excelforum.com/member.php...o&userid=25542
View this thread: http://www.excelforum.com/showthread...hreadid=495834