Move rows with certain value to separate sheet within the workbook

[KateM]

Hi there,

I am new to using Macro's, and hope someone can help me.
When a value is selected from column "M" from the drop down box, i.e. "weekly" I need all the rows that contain "weekly" to be moved to the sheet labeled "weekly" the same must happen for all other values in the drop down box, each should be moved to the appropriate sheet. I do not want any information removed from the original sheet.
Please can someone step me through this....? (right from the beginning!)
I have attached a copy of the sheet.

Thank you in advance!!!

KMpriority client database - Copy.xlsx

[AB33]

Try attached.

[IgorSharov]

This is my solution. Try it when data is filtered.priority client database - Copy(2).xlsm