"Bowtie63" wrote in message
...
I looked and can not find a similar question, so I apologize if I'm posting
one that has been asked and answered. I have a workbook with multiple
worksheets. I need a summary sheet that collects the totals for the
managers
to veiw. Each worksheets contains 2 tables, each with a total. The users
add rows as needed to each tables, which makes the "Totals" cell move.
How
do I create a summary sheet that can capture the 2 totals field of each
worksheet and have one total in one column and the second total in another
column, along with the worksheet name, as in the following example:

Col A Col B Col C
Sheet1 $35 $0

Any help would be great! Thank you!

Just create simple formulas. For example, if the $35 total is in cell A20 of
Sheet2, in the Col B cell where you want the total to appear, use the
formula
=Sheet2!A20
(Similarly in Col C for the $0 total.)

As users add rows, the totals cells will move, but the references in these
formulas will adjust accordingly.