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!