I made a very basic darts stat sheet to record my darts teams stats comprising of functions to add all scores into a season total sheet.

I had to do this using the same column for each player on every sheet. Can i make a dropdown list that i can select a player and that column will add the stats to the selected player on the season total sheet?

I'll try to explain what i mean better

My sheet = column 1 was always the same player column 2 the same player and those were added together in the season totals for the same player.

what i want if possible = a dropdown list in row 1,2 etc that i can select any player and the scores entered will go on the correct player on the season total sheet.

If some one can point me in the right direction or a tutorial on what i need to learn i would be grateful