Data Filter on another sheet

[Queenofmycastle]

I have a Worksheet Table on one sheet named Employee_Info with about 20 columns on a second sheet I have a form for supervisors for a brief evaluation. I know how to do a data filter using all of the columns but I want to be able to only extract their name, title, and supervisor into a range that is followed by columns with cheekbones. The criteria would be supervisor. Any thoughts?

[Pecoflyer]

Please post a sample sheet showing what you have and what you are trying to achieve - Thx

[Queenofmycastle]

I hope this is sufficient. I made a sample file. I am actually hoping to accomplish both of my wishlist items in this file. The first being that on Table2 a data validation that limits the choices of names to that location. The second that I can populate the form that an outside person will show up to evaluate the employees on that day.

Thanks so much!