Help with macro that can input data while moving cells without compromising formulas

Hello,

In the attachment, I have 4 blocks in sheetA. Let's say in the first and third blocks, we want to move the bottom right most 4 cells down and over right one cell. Then go into our second sheet and input the first line of data in rows 23 and 73. (Similar occurrence with blocks 2 and 4 except the bottom right most cells that should be moved have 2 cells). What is a good way to put this into a macro? I have a third sheet that has the desired outcome that doesn't compromise the formulas.

I tried recording the macro, but this needs to be done every month; and cell ranges are changing after every month. Therefore, a recorded macro would need to be changed every month due to the cells constantly changing each month.

Thank you

Well in my post I did indicate the cells that need to be moved and I even have my excel document with the data, the data that will be overwritten each month and the desired result as an attachment. The problem is that the amount of cells will increase with each month as more months are being added. ie in October, youll have months January through October. In November, youll have months January through November. in December, youll have the entire year. then in January, you'll have the entire previous year in addition to that January being added.

I think you may be reading the post incorrectly. Never does it say things are hard coded to either 2 or 4 depending on the group. The reason for the new monthly data is to create a triangle of sorts in each block of cells. So the desired result should have dangling rows to create that desired triangle within the yellow parts of the blocks.

Ok, the "block of two or four cells" refers to the collection of cells in the second and fourth blocks. I have four total in the worksheet. cell block 1 cell block 2 cell block 3 and cell block 4.

As monthly data gets overwritten (A simple copy and paste by me) as the months progress, more months will be extended outward. Meaning more columns will be added (by me) to each of the rows in the second worksheet.

The goal here is to have this automated (because my real file contains many more blocks of cells and much more data) with macros without compromising the formulas (formulas "WILL BE" in blue cells in the first worksheet and formulas are also in purple).

In the third worksheet, I have a box over which cells need to be moved by moving them down one cell and over one cell as the monthly data comes in. the purple will need to be moved down to make room for the data for that given month.