Similar to @Spectral's answer:

=FILTER(Table1[[Employee Name]:[Employee ID]]; INDEX(Table1; 0; MATCH(A1; Table1[#Headers]; 0)) = "Y")

1. MATCH(A1, Table1[#Headers], 0):

• Looks up the column header entered in A1 within the table headers (Table1[#Headers]).
• Returns the column number corresponding to the entered skill name.

2. INDEX(Table1, 0, MATCH(...)):

• Retrieves the entire column (specified by the column number) from the table.
• 0 as the row argument means all rows are included.

3. FILTER(..., INDEX(...) = "Y"):

• Filters the Employee Name and Employee ID columns (Table1[[Employee Name]:[Employee ID]]) where the selected skill column equals "Y".

4. Dynamic Input in A1:

• By changing the skill name in A1, the formula automatically adjusts to filter based on the corresponding column.