Hi Excel experts!

I am a long time excel user but I have come across a road block so I need some advice.

I am creating a master spreadsheet to pull the numbers of hours worked on multiple time sheets. The master is set up with a list of job numbers in column A and then Employee names across the top. There are 26 time sheet files per employee per year. Each time sheet has the job numbers and the number of hours spent working on each job.

The purpose of the master is to calculate the number of hours spent on each job.

I have attempted to use lookup BUT the job numbers on the time sheets are not listed in numerical order so it doesn't work.

Time sheet columns are set up as follows:
Job Number / Description / hours worked

Any ideas on how to make this work?

I appreciate your help!!

Roxanne