Cost jobs based on hours and job number

[Grunty]

Our company assigns job numbers to each employee's daily hours, for job costing purposes. I've tried to create a spreadsheet that would automatically compile costing data, but with no luck. Can someone show me how to compile each employee's total hours for each job number? Then I need to make a list of the jobs worked that week, with their applied wages.

The attached sheet shows what I do manually. It's so slow, I might as well be using clay tablets and a stylus. I just need a way to populate the Weekly Summary automatically.

Thanks for your help.

Payroll Summary.xlsm