Transfer data from Userform to multiple spreadsheets

My version replaces almost all of your code in the commandbutton click event.

A few things:

1. The reoccuring function only goes to the end of the year since your sheets only appear to be yearly. If you put a date that is at the end of the month, the code does not check for this and will happily try to put a date of February 31st if you start in January. If this need to be addressed, we can revisit later. I just wanted to give you a feel for what I added.
2. I added a Class Calendar popup. This class module works across all versions of Excel, unlike the calendar controls put out by MS, which seem to be on again, off again between versions. You'll have to drag the class and the Userform1 over to your sheet, if you want to use this.
3. You'll have to make sure your Sheet naming conventions all follow GL-MMM, a three letter month. I noticed a GL-SEPT in your example.
4. This userform will take ALL months for the year in one userform.
5. If you happen to put a out-of-season date in, the code will just not store the data. There's no checking to make sure you're in the right year. Again, we can address that later.

I can get to the calendar, but not sure what it does. I double click on a day and a blank userform in VBA opens, how do I input data?

So, you double-click on the date field, a calendar pops up, you select a day, then a blank userform shows? That's really odd!?!?!?!?!?!? I even d/l the sheet here at home, but it works fine.

I did forget to mention that the it's fine if the "Date" data is incorrect, when recurring is selected.

The way I have it written now, it does make a difference. It takes the date you enter, and starts a loop from that month to the end of the year.

So, If you entered 8/7/2014, the code runs a loop from 8-12, inserting 8/7, 9/7, 10/7, 11/7 and 12/7. If you enter a date that represents the last day of the month, Say Jan 31, then you'll have Feb 31, Mar 31, Apr 31... Excel won't care because it will convert the Feb date to Mar 3, on the Feb Sheet.

I think I have the EOMonth thingy worked out.

I also added a short Sub in a standard module so you can call the userform with a Alt-F8 instead of from the editor.