Copy table row to another sheet when a specific cell contains the right word

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?

I can think of various conditions that could be placed on doing that, such as do you want the "drafted player" rows in the same order as the selecting team was entered?

Anyway, if you actually want the row copied over, it'll probably take VBA coding to do that, especially in the order selected.

The other method is via formulas on the second sheet... which isn't quite the same as copying ... and use lookup methods which result in blank cell values for players not yet selected... and if you want them in the order selected, there will have to be a column which provides an order selected value.

Yeah having it in the same order would be good. I'm afraid I don't know what VBA coding is. Is it possible for you to give me a brief run-down on how it works, pertaining to my situation? If not being directed to where I could go to learn about VBA coding would be very helpful.

And how would I use formulas on the second sheet? I figured it would be lookup methods, but I'm not sure exactly which one or how to use it.

Let's just go simple first... suing formulas.

See if the attached example provides enough to get 'er done.