Hi,
I have a MAIN worksheet that I use for managing customer service dates with information for all of my clients in rows. In column "I" there is the month (JANUARY, FEBRUARY ETC) that each client should be visited and what I would like to do is copy the rows with the relevant month into a separate worksheet which is named by month. So any client with "MAY" in the service date has the row copied into the worksheet called "MAY", and any with "SEPTEMBER" are copied into the "SEPTEMBER" worksheet etc.

Is there a formula I can enter in each months worksheet to look at the MAIN worksheet and pull the relevant information in? I would like to have it so that if the clients service month changed from say "AUGUST" to "SEPTEMBER" then by changing the month in the MAIN worksheet it would remove it from the AUGUST worksheet and put it in the SEPTEMBER worksheet.
It goes without saying that any help is gratefully received.
Thanks.