need help with a search formula
 

I have a timesheet that has multiple sheets, one for each month, year
total and Job codes.
I want do a sum of total time(s) spent on my jobs.
In the formula below I would like " My Job" To search my sheet "Job
codes then read the time spent
on a job and insert the sum
=SUMIF(A$43:A$151,"=MY_JOB!a2",G$43:G$151)

The way I have it set up right now I put the actual Job name is in the
formula for each project in the location of MY_JOB for each month.
Thats about 40 jobs x 12months. It works but there is always that one
typo
ANy help would be welcomed