Golf Scorecard help!

All done.

For info, you could also use INDEX/MATCH or VLOOKUP to populate the tee numbers and handicap numbers from the "Names and Handicaps" worksheet. That way if you change the names, they would update too. Just makes things easier for you and eliminates the human error side of things.