Bradley,

it's very easy to do this.
In your summary sheet, simply use a formula to link back to the
original worksheets.

eg In sheet1 you have a value of 1 in cell A1, 2 in cell A2

To total these in the summary sheet enter the formula
=Sheet1!A1+Sheet1!A2

Entering such formulae is also very simple.
When you are in the summary sheet, put in an = sign, then switch to the
other sheet(s) and place mouse over required cells. Then hit enter.


--
JulianActon
------------------------------------------------------------------------
JulianActon's Profile: http://www.excelforum.com/member.php...o&userid=14921
View this thread: http://www.excelforum.com/showthread...hreadid=487953