Updating report columns

I have a sheet that is used for financials. It has columns 12 months out. After each month the columns change to the next 12 months and so on. I have many reports that utilize this sheet. However, when the month column name changes all the reports break. I realize I can go into each of the reports and fix each column but that is very manual. Is there any way to get the columns in the report to be automatically updated with the new column names?