Previously I had a post about incrementing the cell value through the use of a button. The thread can be found here, and this solution works great since the columns here never changed.

I came across another modification which needs to increment the cell reference, but this time, the column is also different each time. Each department has one of these books and the information is pulled by various people so we cannot change layouts, tabs, etc. I am just trying to automate some of the weekly task work by using a button.

Looking at the example book....
1) The users will fill in the remaining day of information on the "Daily" tab (B24:E24), and this will fill in on the "Weekly Totals" tab.
2) On the first day of a new week, the user inserts a column on the "Weekly Totals" tab between C & D. This creates a blank column D and shifts the information over to Column E - M.
3) Then they hide row C.
4) Then the information in M2:M7 is pasted into column d as values only.
5) Then the user has to manually change the dates in E1:K1 to the next week (E1 = 1/22, F1 = 1/23, etc...)
6) Then the user has to manually increase all the cell references in E2:K3 and E5:K6 by 7 to point to the next week's worth. (E2 is now =Daily!B26) without disrupting the formulas in rows 4 and 7.

The users now repeat this process filling in information for the new week. At the end of the week they would repeat the process to add a new row, hide the one closest to the row headings, copy the information from M (which the next time would then be row N) into the new row and update all the cell references.

I would like to just have a button they can push at the beginning of each new week that will automatically do steps 2-6 so all they need to do is enter the information on the Daily tab. I thought I knew how to do this, but since my columns are also ever changing, I'm not sure how.

Help?!

Example Book.xls