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!

Pl see the attached file.
Formulas are given in "Converted" Sheet.Similarly You can do for other sheets.

I really appreciate your help, But I think I need something that is going to automatically update to from the list. I also have data that is going to exceed 32 rows. Again I am new to this and I cant seem to get the formula to update once its in A2 in each sheet.
Any and all help would be greatly appreciated!

thanks

Pl see the attached file.

H Jocatlett. Try if this upper solution is some for you. If not i maybe have time but first i guess on sunday to try make a solution with macroes for you. I am quite sure it can be done. But its a little workload to make it. So dont loose hope. But see if this upper solution is ok. Otherwise let me know and i will try make the solution with macroes.
Sincerly Abjac