I have a workbook that I create a new worksheet in each week.
These worksheets have a coulmn for each day of the week, then 3 columns
"Weekly Total", "Previous Total", "Total To Date".

Is there a way to have the Previous Total on the new sheet automatically
know that I am refering to the very last sheet?

Right now I right click on the tab copy the sheet and then click in each
cell in column K to update last weeks sheet column L
(for example ='1'!L7 is the formula in cell K7 sheet 2).

I use this workbook to track project quantities added to a job
(construction) then I have to transfer the these totals to quickbooks and to
pay applications and a few other places before I can mail out our bills to
the prime contractors we work for. It's all so time consuming so I was hoping
someone may know a secret to help me so I dont have to copy and paste and
click and retype each formula

Hopefully I am explaining my problem correctly.

--
Thank you for your help