Copy last weeks figures automatically

[atmospheric]

I have a worksheet with 13 tabs, each tab represents sales for each week of a given quarter, i.e. 13 weeks.

Each sheet breaks down sales by dept (20 Dept's) and compares This Week v Last Week.

Having completed Week 1's figures, what is the simplest way to copy Week 1's "This Week" into Week 2's "Last Week" Figures and so on for ultimately, all 13 weeks, without manually copying basic formula from one sheet to the next, 13 times?

Any help would be appreciated, especially with coding (if that's needed!)

 

[texasalynn]

what are the formulas you are using?

 

[atmospheric]

Simply the old fashioned way e.g. ='Week 1'!G5

Each "Last Week" cell referring to the previous sheets "This Week" cell for that Dept.

This method will work, I just thought there may be a slicker, quicker more professional way!

Thanks for your response