linking sheets

[Guest]

sheet 1 has the 7 days of wk. sheet 2 has the whole month.how do i keep the totals from the previous wk intact when i start to work on new wk.

 

[Corni]

Do you really need to link Sheet1 and Sheet2. Is a little bit of a temptation to link or automate, but try to reason if there is any advantage for this. In your particular case, why not copy and paste from sheet1 to sheet2 in the relevant cells.
I would use formulas if were for ex. twelve months in twelve sheets, and would like to input in a weekly template data that should be then placed in the right month and the relevant dates. In this case you need to have two cells on top of the weekly table with the start date and the end date of the week.