I have got rolling 12 months as headers from cell B10 through to Cell M10.

If this month cell B10 is April08, next month this cell will be May08 and the month after it will be June08 and so on.

Is there any formula/function to automate this process? At the moment I manually update the rolling 12 months in each cell every month, which is highly time consuming for 46 files.