Code to hide columns based on date criteria and insert another column with formulas

There are a lot of posts on hiding and unhiding columns but so far I haven't been able to piece together what I need. I have a spreadsheet with showing weekly dates spread across the top. My goal is to always show six months of data starting with the current week. Each week I want all previous weeks to automatically hide, and then I want to insert a column at the end to round out my six months (i.e. 24 weeks). Workbook attached but here is the setup,

Columns A-M contain other data
Column N starts the date columns. Date at the top and formulas down the column beneath.
24 columns worth of dates and then another "non-date" column

In short, the manual process on Friday would be: Hide column n, insert a column after column AK. In the new column AL, copy all of the formulas from column AK over to AL which will populate the next weeks date and all of the data.

The next week, both columns N and M would be hidden and the column insert would be after column AL. And so on and so forth.

In the workbook there are two tabs. One showing current status and one showing several weeks into the future.

I have several different spreadsheets to apply this macro to, all with the same general setup. I'll just need to be able to modify which column the dates start in.

Any help would be much appreciated!!!