Matching a Row from Table 1 to a Row in Table 2 (non-numeric), and as a result show a cell

I have two tables where i am trying to match a row from table 1 to table 2. If the row matches, i want to display a specific cell in table 2 in a seperate column not affiliated to the previous 2 tables.

Real world/actual application/situation:
I have a race team of 20 people and a total of 50 races.
Each person has a tab in the excel workbook and they are to put an "x" in the corresponding cell of a table that shows yes they are going (indicated by an "X" in the cell) next to a list of avaialbe races they can participating in.

I have a "team" tab that is trying to tally the "person" tabs in a cell. (if the person puts an "x" in the cell on thier individual tab, indicating they are going to participate in that race thier name (which is the tab name) will appear on the "team" tab, also - if they are not going to participate it leaves thier name off/blank of the desired outcome/cell, so if no one is going to that race, the cell is blank, if 3 people are going it ONLY shows the three people that are going - preferable with a comma and a space between the names except for the last one...i.e. "Dan, Joe, Tom")

This is to make it so i can see the team tab, and be able to see all who are going to participate in any give race without having to look through each individual tab.

Table 1 = Actual inputs
Table 2 = all possible outcomes

I'm sure there is a better way to do this, but this is what i have now and i can't seem to get the result i want...please help!

also, if the outcomes can add a comma and a space to the names if another name comes after it to make it easier to read that would be awesome. I tried nesting but i had 91 possible outcomes and it only allows up to 64.

ALSO-this may help
Table 1
I have accross the top of the tables the 20 person names
I have on the first column the 50 names of the races
there is a corresponding "x" under the name in the row of the race they are participating in

Table 2
Same conficguration top - 20 person names
First column - 50 race names
-All possible outcomes-
Additional column on the end of the table with the names of each person that has an "x" in that row