So I have a workbook with 9 sheets of data and 9 more sheets of charts and
graphs that feed off of that data. The nine sheets of data rotate each week.
Week 1 of data rolls off and a new week 9 of data rolls on. I'm working on
do this via a macro. Here's the problem: the two options I know of are to
copy and paste all of the data from each sheet to next sheet (i.e. copy week
2 data and paste on week 1 sheet, copy week 3 and pasted on week 2, etc.) OR
I could have the macro just rename the sheets. For obvious reasons that would
be the preferred method. However, it screws my formulas up because when I
rename Week 2 to Week 1 and so forth, my formulas change with them. Such a
handy little function of Excel. Except it's screwing up my workbook!!! I need
the formulas to remain the same!

Is there some code that will allow me to bypass or turn off the sheet name
updates until my macro is finished running?

Any suggestions would be most appreciated!