Moving data from one worksheet to another

I am using a userform in excel 2003 to enter budget data onto a spreadsheet (sheet1). That data includes a cost code, date, value, order no. I want to be a able to copy the rows of data from sheet1 into other worksheets labelled April, May, June, July etc dependant on the dates listed in column C i.e all rows with April in column C to be copied to worksheet April, all rows with May to be copied to worksheet May etc.

Any help would be very gratefully received.