I'm coaching a team of youngsters, and would like to track individual stats
by game (1 worksheet per game) and totals for the season. The only problem I
have is that the batting order is going to change every game (league rule).
Player1 would be in row 1 one day and row 8 the next.

So I thought that I could use the name function for each player and each
stat. Something along the lines of, SUM(Player1 Hits) in the Season Total
sheet. But you can't use the same name across sheets, and obviously the above
formula wil not work. Any chance I can make this work? Thanks!!!!