Here is my problem:

I have some payroll information for two jointly owned businesses that have about 6 joint employees (out of around 60 total) from the last 2 years that includes employee names and hours worked. Each sheet is a different pay period for each location so I have 104 sheets in my workbook. Employees have come and gone so each pay period is a little different. What I need to be able to do is sort through all of the pay periods, figure out which employees were working at both locations and then add their hours worked to get one total per pay period. I could obviously print all of this out and go through it by hand but I'm trying to think of a way to get Excel to do this for me.

A simple example would be something like this:

Janet 5 Bobby 4
Greg 4 Janet 7
Sallie 8 Sue 13
Jimmy 12 Sallie 4

Then, I need excel to be able to sort through this info and recognize that Janet and Sallie are in both columns so I need their total.

Any ideas??