copy and paste rows based on criteria in column

Please see attached document, it will help you understand what I am looking to do. I would like to have the rows that have a "Y" in column D to be compiled into the filtered worksheet; I hoping to achieve this with some sort of excel command(s), do not want to have to manually filter and copy and paste into the other worksheet each time. Kind of like I want the filtered information only to show up in the filtered worksheet, the issue is I do not want to use VBA coding to get this done. See sheet 3, it would give you an idea of what I am looking to achieve.

I hope someone out there can help me with this, I appreciate all the help I can get. Thanks in advance.

CharlieZangel