Macro to move data from one sheet to multiple sheet

Hi

I am having a shared file in which multiple users shall input the data in the sheet "Allocate". I need a macro to move the data when they submit the button "Allocate" to the respective sheets based on the criteria selected from the drop down list " Jan 2015" or "Feb 2015" etc. The users can enter the data in any of the rows in the column(B:N) and it can be single row or multi rows.
I have attached the sample file better understanding

Maybe:

Please Login or Register  to view this content.

Thanks Mangesh,

Two more additional inputs required.
I need the data from the sheet "allocate" to be moved on the row below the existing data of other sheets, as it is a continuous process of updating new rows.
At the same time, the data should get disappeared from the sheet "allocate"

regards
Sreejesh