I am creating a Game scoresheet and would like to know if I can use a drop
down menu in one cell and automatically fill the below cells with players of
the drop down selected team.

example

cell 1 TEAM1 TEAM2 <--these are
drop down menus

cell 2 PLayer1 PLayer5
cell 3 Player 2 Player6
cell 4 Player3 Player7
cell 5 Player 4 Player8