How to Copy Rows with same values in a certain column to new sheet with in the workbook

I am brand new to Macros... I have a spread sheet in excel with 8 columns and a lot of rows (I will be adding to this spread sheet daily).

I am trying to filter the results based on the status column (G)... I have a drop down box in the status column with 6 options.
Status
1 Converted
2 CXL / Rescheduled
3 No Idea
4 No Show
5 No ROF
6 Declined Care



I would like to have those 6 options as new sheets and have the patients organize with there status.

So basically copying the pasting the rows with out deleting any of the criteria that is in the row already. I would like to keep the main Data list (page 1) stay and not be deleted when they are moved to the appropriate sheet.


As if that is not enough lol .... I would also like to be able to filter simultaneously another column (A) based on Event type

Event types
1 Massage Event
2 Dinner Talk
3 Lunch & Learn
4 Health Fair

Im not sure if it is possible to have 2 filters at the same time but I am hoping someone can help me!