Keeping Stats across multiple sheets, including potential new sheets being added each week

​

I'm trying to create a sheet that tracks Wins/Losses/Draws across 15 players, with multiple practices and multiple games within those practices.

So far I have a new sheet for each practice titled "Practice1" "Practice2", etc. within these sheets I have 4 columns, Name, Win, Loss, and Draw. In the A column are the players names, and because there are multiple games with different partners and opponents each week, their names show up multiple times, and in different lines each sheet. Currently I have a sumif formula in a "Standings" sheet, which for the Wins section in Column B looks like

=SUMIF(Practice1!A1:A50,"NAME",Practice1!B1:B50)+SUMIF(Practice2!A1:A50,"NAME",Practice2!B1:B50)+SUMIF(Practice3!A1:A50,"NAME",Practice3!B1:B50)

I have this set up for each player name, as well as for certain activities we do frequently, which I keep within specific ranges in each sheet for consistency, so with 15 players and 5 different activities I have 75 similar formulas going just for the Wins column.

The issue is every practice I have to add a sheet, which means I have to update each formula to include the new sheet, so it ultimately isn't saving me that much time. Is there a smoother more efficient way for me to do this? I've read a bit about Book End technique and Named Ranges but having some trouble wrapping my head around it.

Please let me know if there's anything I can clarify or additional info that may be helpful. Thank you!