Submit Button script that moves information from host sheet to speciic sheets by month.

Question

I have a woorkbook in excel where the fist sheet is a form that is filled out and printed to be attached to inventory. I have been able to add an ActiveX Control and script to print the page and clear the entered data, separate buttons of course. I also want to add a "Submit" button so information on the main sheet can be copied to another sheet. However, I need to have it by month (each sheet is by month) and I have a drop down list on the entry sheet with the months listed. Is this possible?