How to copy row data matching specific column criteria

mtarler I'm still working with your FILTER idea. Tried pivot table too. I keep coming back to how do I

setup the FILTER to be aware of the 10 names that do not change but may appear in today's daily report?

Here's a very small subset of my data. Names were changed. I'm trying to copy the rows that match certain names in column E to another spreadsheet (DailyRptB.xlsx). I'm really only concerned with matching on names, not numbers. For simplicity sake say Terri cooper, Barbara, Connie, JC Frank names are the rows I want to MATCH and FILTER on. Whatever FILTER criteria I use, tomorrow the column values may not have Terri, Barbra etc. but have Yuri, Tiffany, Marc (who also comprise my unique group of Sales people). 

SO my Filter should incorporate those names too in case they show up during the week.

Will my Filter function look like this?

=FILTER(A:A,ISNUMBER(MATCH($E:$E="Terri Cooper","Barbara","Connie","JC Frank","Yuri","Tiffany","Marc"$B:$G)))

Then how does the copy to another spreadsheet work?