Let me explain what I have already done and what I want to do.

Sheet1 C5 is the HOME field.
Sheet1 E5 is the VISITOR field.
In C5 and E5 the games coordinator types in a number that references a team.

Sheet1 C12 is HOME team name.
This is automatically set when I type in the number in C5;
=vlookup(C5;$Sheet3.A17:B23;2;0)

Sheet3 A17 through A23 is 1 - 7 (the number of teams we have this
season) and B17 through B23 is the team name.

In B15 is the first player jersey number.
In C15 is the first player name.

Sheet7 is the Team Roster
Column A
A1 = 1st Team Name = Red
A2 = First Player
A11 = Last Red Team Player

A13 = 2nd Team Name = Green
A14 = First Player
A23 = Last Green Team Player

What I wanted to happen is, when I type the team number in C&E5 besides
the team name being filled in I want to copy the players and jersey
numbers for all the members.