To be a bit more specific

Tab 1
Name hours worked amount earned
Emp1 5 $45
Emp2 3 $18
Emp3 10 $100

Tab 2
Name hours worked amount earned
Emp1 7 $56
Emp2 8 $48
Emp3 5 $50

Tab 3- Report
Name hours worked amount earned
Emp1 =total from tab1&tab2 " "
Emp2 " " " "
Emp3 " " " "


Thanks for any help

"Rob" wrote:

I have one worksheet with multiple tabs for each pay period (we get paid
every 2 weeks). Each tab has an employee name, how many hours they worked,
how much they got paid and the total they were paid.

What I want to do is make a "report" page which would go through each of the
tabs and sum all of the hours worked for a specific employee, add up all of
the money they were paid from each of the tabs.

How do I do that?