If your code works how about reversing the order of the months to
insert a new column A for each new month moving the prior months to
the right? Then the columns A to E will be the last 5 months. Someone
I'm sure can write some code to do what you need but I look for the
simple first.