Fastest way to copy old workbook into new workbook to change to current year and wk ending

I have a workbook with 62 sheets to run my apartment complex. 52 sheets are for the different wk ending dates for the year. Each sheet has information from the previous week and master sheet. The other 10 sheets are the Master and various summary sheets that pull from the 52 week sheets. I now need to make up a 2013 workbook and change the 52 week ending dates. I know I can do a copy of my old workbook and get rid of the source reference but what is the fastest way to change the week ending dates AND when changed, will it change all the formulas that refer to the previous weeks? or what is the faster way to change the formulas to correspond to the new sheet names? I have been able to figure out how to make a new workbook with the 52 wk new ending dates but how do I get the old sheets into the new (blank) sheets and will the formulas automatically change? I hope someone understands what I need. Thanks for any help.

The workbook works great. There are too many units and too many catagories to not have a weekly sheet. I just now need to quickly update it. I can spend a lot of hours doing it manually because I know no other way but I thought I would ask this time. I was able to find some code to make a new workbook and do the 52 new wk ending dates correct but can this code be changed to change the 52 wk endings in my old workbook somehow? And will the formulas automatically change with the new sheet names or does something more need to be done?

Please Login or Register  to view this content.

Thanks, Karen