Hi! First post here--found the forum by googling "Excel forums" and here we are!

I know basic Excel. I use it rarely so I usually have to investigate how to do various things when I need to, but typically have kept to basic sums, etc.

Here is what I'd like to do:

I have a high school girls volleyball team. I'd like to list their names in a column followed by jersey number. I'd then like to have columns headed by individual stats... serves, missed serves, kills, digs, dives, etc. Simple enough. I'd like to use a sheet per game, so if they play a three game match, I'd track stats for each game. (As I write this, perhaps I'll make a sheet per match, but three columns under each stat representing each game).

I would then like a sheet where totals and averages end up. I've never done any Excel stats/sums/percentages across multiple sheets. So lets say Sally has played in every game, I'd like a sheet where her stats automatically accumulate and possibly average (like percent missed serves).

Now. Would it be best to do this within a single file? Each sheet could either represent a match or a game? I'm planning on printing blank copies for my manager to pencil tally during the game and enter during practice.

Any help or advice would be appreciated. If a similar situation is already written up in a tutorial somewhere a link would be great. Thanks!