Reverse Index Match return names from table data

Hi,
Hoping someone can help,
I have a table with names in the left column and columns of the months
the table is populated with data (Ys) (this represents if someone did something in the month)


I want to enter a month in a cell (G1 in example)
An have alist created of the names that correspond to having a "Y" in the column matching the month.

For example if I entered Jan I want to return a list of the names that have a "Y" in the Jan column.

I hope this is clear.
EDIT: to clarify my request, I am hoping for a none VBA solution.
also hoping to use the solution in another worksheet where the number of columns may be very large.

please let me know if more info is needed.
I searched but could not find anything, I may not be seaching the correct terms?)
Capture.JPG
Regards,
Brad