I am attempting to create a fantasy football draft spreadsheet where I
can leep track of the players the other teams select. In my current
workbook I have multiple worksheets for RB, WR, TE, etc.. Columns A
and B have the first and last name. Column C has the NFL team, Column
D the player position (which is redundant since each sheet only
contains a single position). Column J has a drop down list for each
Fantasy Football Team. Currently when I select a team from the list it
changes the row color to gray, which tells me the player has been
selected. What I want to do now is when I select a team from the drop
down list copy the player name to another spreadsheet which has the
players listed under each team like this:

Barnies Ballers Head Knockers
1. Peyton Manning 1. Shaun Alexander
..... ...
14 Kevin Jones 14. Hines Ward

Even more elaborate would have the players listed under each team but
broken out by position under each team like this:

Barnies Ballers
QB 1 Peyton Manning RB 1 Larry Johnson WR 1 Randy Moss
RB 2 Kevin Jones

If its too hard to do on a single spreadsheet multiple sheets one for
each team would ne okay as well. Any help would be greatly
appreciated.