Auto fill after adding name

[stkin]

I have an excel sheet with 8 pages on it and they are labeled with golf course names. On each page is the name of all players and their handicap for each set of tees on that course.
I would like to have a sheet where I can enter each team with the players name and it auto fills in the HC for each player.

On the game sheet I have the following
Player W WS S G
It means name and then white tees, white/silver tees, silver tees and gold tees.

I have all the HC’s figured on each course.

On the main sheet I would like to use a drop down list for the course then add the player name and let it auto fill the HC’s.



Thanks

 

[mumps]

It would be easier to help if you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).