SUMIF across multiple tabs

I've searched the forum and found a similar question, but alas, it had no posted answer. Perhaps someone has come up with an answer since the original poster asked their question, so I'll ask mine and hope for the best

I have a series of tabs where I'm keeping up with stats for a soccer game. Players' Names down the rows and stats (shots on goal, shots made, etc.) across the columns. I have a separate tab for each game played.

I have a summary tab, where I'm totalling the stats for the entire year. Currently I'm using a simple SUM formula. SUM('Game1:Game10'!B7) for example for the player on row 7. This works great as long as I have the Players' Names in exactly the same row on each tab. But as players come and go, this is beginning to be an annoyance.

I attempted to change my SUM formula to an SUMIF formula. But SUMIF doesn't appear to like using a range of tabs.

=SUMIF('Game1:Game10'!A:A,$A7,'Game1:Game10'!B:B) returns #VALUE!

Am I attempting to do something that can't be done or do I have an error in my formula?

Any other suggestions for how to accomplish my goal?

Yes, I do believe that is what I need. I ran across a similar website yesterday afternoon in my continued search.

I really appreciate your responding to my question.

I knew there had to be a way to do it. I had read about the SUMPRODUCT function before, but had never used it. I love to learn new stuff!

Thanks again!