How do I make a total sheet?

[Guest]

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

 

[Del Cotter]

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.

A lot of people are asking about spreadsheet solutions here lately, but
really this is microsoft.public.excel.charting, the newsgroup for using
Excel's graph facility. Have you seen
microsoft.public.excel.worksheet.functions?