I am working to create a wait list for our clients that will automatically sort the rows of information in a master clients sheet based on cell values of Y or N. If a cell in a certain column has a Y value (such as the FG column) I would like all such clients that have a Y value in that column to be automatically copied to the FG worksheet, etc.

How do I do this?

I can sort the information/copy to another sheet using advanced filtering options but then it doesn't automatically update when information changes on the master sheet.

I've been watching a lot of tutorial videos and looking through some forums but haven't been able to figure this out.

Can anyone please help me?