How to copy row data matching specific column criteria

jazmarc You may want to use a pivot table for this and filter by the names you are interested in.  You could even add a slicer to easily select those names.

Alternatively, if you have the up to date Excel with dynamic arrays you should have a function called FILTER() which can make this process relatively easier if you have something against pivot tables.  Basically you can use:

=FILTER(A:A,ISNUMBER(MATCH($AO:$AO,$CC:$CC)))

where I have the names listed in column CC (you could change that to a different column, different sheet, or defined name) 

and then copy that right for however many columns you need.