write a macro to either hide or delete the month gone.
cells(row,col).entirecolumn.delete

then insert the next month at the end of the period by using fill.

It should be easy enough to record this if you're not experienced with coding.