you need to add an additional worksheet for a summary sheet.
all your worksheets need to be set up with the same format.

then, on the summary sheet, you can tell that cell to sum through all
52 worksheets & give you the total for each job.
=SUM(Sheet1:Sheet12!B6)
you can do this with formulas, you don't need a macro.
hth
susan



On Feb 23, 11:32 am, "Apollo55" wrote:
Hey all, I submit a time sheet each week for the different jobs I
have worked on. I am trying to make a spreadsheet to totalize how
many hours I have spent on a single job over the course of a year. I
have all my time sheets in one Excel file on multiple sheets. How can
I do this? Any help is appreciated.

A typical time sheet looks somewhat like this:
Job name Job # M T W Th F Sa Su Total

I envision the totalization to look something like this:
Job # Total time spent Total $$ spent

Thx.