That's good, but as you said all worksheets need to have the same
format. For your example, the formula sums all of the B6 cells
regardless if they have the same job number. One week, cell B6 could
be job 01, the next week it could be 12. So I need to do some more in
depth programming.

Right now on my summary worksheet I have an If(CountIf)) statement to
bring all the job #'s onto the new worksheet. I then filter out the
duplicates and spaces to give me a list of all the job #'s. I am
working on writing a VLOOKUP function to totalize the hours per job.
The one problem (if I can get it to work) is that it's not very
friendly to add additional worksheets to, as each week a new worksheet
gets added.

There's got to be an easier way!

Thx.