Need VBA to add month/year column and delete month/year column

I have a situation in excel and I have no idea where to start with writing the VBA code.

This is what I have been requested to do:

It is a spreadsheet with columns for the months of the year. I was asked that the spreadsheet show one year at a time - so when a month changes, so do the columns. When February 2013 is showing, all the months will show up until January 2014. The month after would be March 2013 up to February 2014.

I usually work in databases, but I don't see that working for this. Also, there are some formulas in this spreadsheet. They are not complicated. They just add up hours for different employees on different projects.

It seems to me that there should be some sort of coding that can do this for the user.

Does anyone have any ideas?

Attached is a copy.

Let me verify what you're asking. You're saying that you want cells D1:N1 to change based on the month in cell C1? How does the cell in C1 change? Will it be the current month or will users change it manually?

I want the display to automatically show one year of months. So, if the user deletes, say column C, then the another column shows up after the last one.
Column C is deleted (January - 2013) and a new column appears after December 2013 (January - 2014). This should continue eveytime a column is deleted. When the column for February 2013 is deleted, a column for February 2014 should show up.

Now for the super embarrasing question:

How do I make this run?

Wait! I totally get it!

IT WORKS!!!!!

I am going to show it to my user now.

THANK YOU!!!!