Does anyone know how I might be able to do the following problem. I
have a workbook broken down with multiple sheets by player position
(QB, RB, WR, etc)

Ex - QB Page
ColA ColB ColC ColD-F ColG
FirstNm LastNm Team Various LTeam

ColG is a drop down list of teams to assign the player. When I make
this selection I would like to have ColA, ColB, and ColC copied to the
appropriate section of another sheet which would look like this

LTEAM (static)
ColA ColB ColC ColD ColE ColF
QB1 <firstName Last Name <Team RB1 <first,last Team
QB2 RB2
QB3 RB3
RB4

The above sheet would be broken down by LTeam and the player selected
would be populated in the next available slot.

Can anyone help? Thanks