Is there a way to populate a list from a common criteria in a table. What I have is a bunch of names of employees working under a few workorders. I am trying to create a sheet where all you have to do is enter the workorder number on the top of the sheet and it will pull a list of all the employees working under that workorder number.

So for example in tab "A" I have:

Name.......................W/O#

John S......................1111
Jason P.....................2222
Jane D......................1111
Eddie T.....................2222
Saun S......................1111

Now I want to be able to enter 1111 into a cell at the top of the sheet and have it return:

John S
Jane D
Saun S

It would be like an Autofilter but use it based on what was entered into a cell and pull from another tab. Is this possible or do I need to go back and set it up where I can just use auto filter