Sorting User Time sheets by Job No. from referenced Sheet 1

Hello Excel Community,
The title probably makes no sense but i'll try to explain. I work at an engineering firm that records jobs by a job number. What I would like to do is copy and paste the individuals timesheet into SHEET1. On SHEET2 I would like the timesheets to sort by job number so our accountant can easily add all the hours up by a particular job number. Here is an example of what I am dealing with. Master Job no sort.xlsx

The Timesheets to be copied into SHEET1 would be standard format so the employees have less of a chance to screw it up. This process would be done on a weekly basis by the accountant so by the end of the week there would be quite a bit of job numbers to sort through. I am just trying to speed up the process.

Thanks for any help.

Thanks Melvinrobb,

Im not too familiar with pivot table so Ill do some research but it looks like what I'm looking for.

Thanks Melvinrobb,

Im not too familiar with pivot table so Ill do some research but it looks like what I'm looking for.