Creating a new table from a reference table

I'm looking for a more elegant solution to my problem and I'm too new to excel to figure out the best way to fix it. I'd like to create table which is a subset of entries from a reference table based on whether the name is found within the text of a particular cell.

For example, I have a reference table of potential participants (Jake, Mark, Elizabeth, Hope, Abigail, Jose, etc.). In my reference table, each participant's name is listed in Column A, and Columns B, C, and D have information that pertains to that participant (age, height, weight). I receive an email which include several names from the list of potential of participants (Mark, Abigail, and Jose). I want to be able to copy the text of that email into a cell (or into a word doc if that works better) and have Excel create a table based on the names found in that email and include all of the corresponding information (age, height, weight) found in the reference table. So, in the end I would have a table with Mark, Abigail, and Jose's information.

In my case, there are many potential participants and the email that I receive is pretty large so the resulting reference table may have 100 entries and the resulting table may have 20 entries. I hope this makes sense and I characterized the problem appropriately and used the proper terminology. I'm sure that the resulting formulas will use VLOOKUP, but I'm just not sure how to get the information from the email.

Thank you for your help!

Kaper, Thank you for responding so quickly! I think that my main problem is retrieving the names from the email. The email is very long and the names are randomly spread throughout. I currently have a table set up with all potential names in Column A, and Column B has a formula that outputs "Yes" if the name in Column A is found in the email [=IF(AND(A2<>"",ISNUMBER(SEARCH(A2,A87))),"Yes","")]. The email is copied into cell A87. The remaining columns have the IF "YES" then VLOOKUP function [=IF(B2="Yes",VLOOKUP(A2,Sheet1!$A:$Y,3,FALSE),"")]. Sheet1 has my reference table. This results in what I need but it has a lot of blank rows. I guess I really just need help transforming the names found randomly in the large email into a list in Column A, then I can use VLOOKUP for the rest. Thanks again for helping me think through this.

Dziękuję, Kaper! That works great!