I've got a workbook that contains a payroll worksheet for each employee (9).
I would like to have one sheet that takes information from each sheet and
then provides a total.  For example, I want the total amount paid out for a
payroll period for all the employees listed on my total sheet.  

Each Sheet looks like this:
                  Payroll    Commission    Auto Allowance
08/31/07     1500.00           0.00                 0.00
09/15/07     1500.00        200.00             600.00

I want a sheet that combines the information for all employees and provides
totals to look like this so I can have totals for each pay period:

                  Payroll      Commission    Auto Allowance
08/31/07     20000.00          0.00                      0.00
09/15/07     20000.00        1000.00            10000.00