Creating scoresheet to autofill selected areas

Hello all,

Assigned with a project of creating a score sheet for our local netball club, in my search i came across this thread which is something similar i was trying to achieve.

http://www.excelforum.com/excel-gene...coresheet.html

From the sheet attached, i was hoping to autofill names of the teams (Highlighted in Green) and to populate details (Highlighted in Red) and populate the corresponding players from those teams (Highlighted in Yellow) on the score sheets but not sure what will be the simplest way to do it.

As you can see i have the main sheet SCORE SHEET TEMPLATE which will be used to print once it is populated with the teams and their players (Under 11 Teams) for each round (Under 11 Fixture). I was thinking to use a simplified drop down menu on the SCORE SHEET TEMPLATE to automatically populate the names but not sure what the best way to go about it would be (or easiest).

I am happy to plough through it once i have a bit of guidance and look forward to compiling it exactly how i would like it. Ultimately there would be many grades (Under 11 - 17) and will save so much time from the current cut and paste regime they are now using.

All help and suggestions are most appreciated.

Regards
Rob