Baseball stats?

Could someone help me with this please.

I am trying to get a lookup of each player totals. There will be a total of 16 games, 16 sheets.........for each game. I have the information i need for the individual games, but would like an overview of all games combined. I only need the player stats to show on the overview sheet. I am not certain how to get this done.

The batting order for each game can change, so the overview needs to lookup names from each game...even if its in a different order.

E7 - on the overview is my first try at what might work.....obviously, i have no idea what to do.

Thanks