Copy paste formula to another column with blanks in between

Hi! I have this spreadsheet with many small tables on it, each table contains raw data on some rows, and formulas on some rows (sum, ratio etc.) I have to update the spreadsheet every month, so I need to add a new column each month. I want to copy only the formulas from last month to the new column, but if I use ctrl+select the formulas in the first column and copy them to the new column, the formulas won't go to their corresponding rows.

Is there any ways to solve this problem other than drag the formula down each individually for every row that has formulas in it? Thank you!

Hi! Thank you for the response. I have a sample data with 11 tables on it. Every table has the same structure.
The rows with bold number are formulas and the rows with blue font are raw data that I need to input every month.
I only want to copy the formulas to a new column such that when I input July data on the spreadsheet, the calculation can be done instantly.
However, if I just choose the cells that I want to copy formulas for, when I paste to the new column, it will paste down and cover the cells that are suppose to have raw data.
It seems like Excel doesn't paste formulas to the corresponding rows as previous column.

Thank you!