I agree with Bill and would probably take a Data Filter path.
However, if it must be in a separate sheet, try a pivot table. Select
any cell in the data sheet, then follow the wizard launched from the
menu path Data Pivot Tables and Pivot Charts. When it is time to
drag and drop fields, drop the "Name" field in the column area far to
the left and drop the "Position" field in the Page area at the top.
Depending on your data, you may drop other fields on the top row or in
the data area but you didn't indicate that you needed more than a list.
Finish off the wizard.

At the top of the pivot table, select the "Position" from the drop down
list and presto.

- John