automatically copying rows to an existing spreadsheet based on criteria

I have an excel spread sheet that I would like to automatically copy rows based on Status (which is a column header with a drop down list) (No Show, No ROF, Converted, Declined Care, Money Issue) on my NPI tab. I will be adding to this spread sheet daily so the data range needs to be large.

I do have macros on the first sheet that inputs patients i Enter in (in Forms) to NPI (sheet) I would like that to stay the way it is if possible.

I have the spread sheet set up to where I would like the rows to be duplicated so I can see what a patients status are group by common status. I would like all of the patients to stay in NPI and not be deleted once copied to another sheet.

2nd I would also Like to group the NPI based on Event Type (massage, Lunch & Learn, Dinner Workshop, Health Fair) I have the tabs in place. I would just like the same thing from above. The patients to be added to one of the Event Type sheets based on which category the fall under .

I have been struggling with this for ever and about to give up.. If someone could please help me it would be a lifesaver!!