How to see data everytime a value appears in multiple columns

I am usually pretty good at excel, but can't seem to figure out how to do this. Can someone itch my scratch by giving me the ah ha moment!?!?

I'm trying to show data every time a name appears in multiple columns. For example, raw data is:
Client Name1 Name2 Name3 Name4 $ Month WIN
Ford Andrew Carla Maria Jeff $25 April Yes
Coke Carla Andrew $30 May No
IBM Maria Andrew $20 June Yes


I want to see the client, $, month, & win for everytime "Andrew" appears in either Name1, Name2, Name3, or Name 4.

I have a pivot table built, but I can't reference "Name" to look up all four columns. (Name1, Name2, Name3, Name4)

Please!!