search multiple sheets, combine data, post all results

This may be in wrong area so mod may move if necessary.

What I am trying to do

1. Have created a seperate time sheet for each field employee. On time sheet I have day worked, Job#, Job Name, expenses Hours worked. What I would like to do is for my results page to look at each employee time sheet. If job number is the same I want it to combine all hours and be able to post in results.

Couple of example

Time sheet( Joe dirt)employee name

Monday 2731(job #) Billy bar $30 (expenses) 8 Hrs worked
8/25/14

Time sheet( employee)

Wednesday 2731 Billy bar $0 expense 8 hrs worked
8/27/14

in the results I would like returned

Job # Job Name Employees worked Total expense Total Hrs Wages Expenses Benefits
2731 Billy Bar Joe dirt $30.00(or what ever it is) 16 $ $ $
Employee


Next job number(all other job # and data as described above


I also need to be able to have different wage rates and expense and benefit rates( be able to change when required. Can have on time sheet of each employee.


I have been trying to figure this out for a while. I can do some complex math functions. If someone can assist I would appreciate it.

I can post an example of result page I have completed that I do by hand. Just don't know how to attached file

Just wondering if anybody had any ideas to accomplish my goal.