I am trying to create an excel for a sport team draft process that I am in charge of that will take place in a while. I want to make it so that on the main page with all the players, that when I type in the team name at the end of the row in the table that that player got drafted onto, it will copy the name of the player onto another sheet in the same workbook. Any thoughts?