Consolidating worksheets
 

I have a blank job order sheet that I list "time spent" on each job. When I
fill in the info, I do a save as and save under company name. I am trying to
create a summary sheet that automatically updates the time whenever I create
a new job. I can get the summary to calculate each job, but I can't figure
out how to have it do a running total for the week? Any help on this would
be greatly appreciated.