Auto-Copy & Paste

We are trying to automate the following process in Excel. Every day, we open a workbook (sample attached) and copy column B to column C and then paste value the formulas in column B. The next day we basically do the same thing only we copy the formulas in column C to column D and paste value column C...and so on...

How can we automate this process so the copy over one column and paste value the previous column can be done using a form button (which we know how to do). We just need help with the code.