Macro that moves Formulas 1 column right and then Pastes Values into previous column

Hi all. I am building a new tool that will help me forecast data based on being X number of days away from my target date.

The formulas (in my example sheet) will be vlookups or SUMIF formulas from data in various other tabs in the sheet.

What I need and can't figure out is how to write a macro that will move the formulas one column to the right and then go back and copy/paste values into the previous column. This is difficult for me to explain in words so I've attached a sheet with 3 tabs that show what I want to see before and after the macro runs.

Any thoughts?

Hi,

Is it just the top vertical formula section that you want to move?
Do you need to shift the bottom matrix to the left also?
Where do the values in the matrix below come from?

Cheers

Yes, both the top and the matrix will be moved.

There are roughly 20 tabs of data that populate the formulas in the upper section.

The matrix section below is populated by only one tab of data.