I'm going to try to explain this as best I can, though I'm admittedly rather wet behind the ears in terms of Excel functions.

Here's what I want to accomplish, I'm wondering not only is it possible, but also perhaps some pointers in the right direction.

I want to have multiple sheets with stats (Sports related) from each team within a specified sports league listed out in a game-by-game format. I want to create a generic formula (if possible as one formula, if not, I'm very open to creating multiples as well) that I can simply duplicate in each sheet to ping for the desired result.

Here's what I'm specifically looking for this formula to do:
1. Based on the team listed as the opponent, use the stats from that team's sheet (so an "if" function, possibly a lookup, not sure, that will check for the proper sheet to get the information needed)
2. Pull the "total" stats (that is, the combined stats of every game of the season) and somehow (this is where I'm truly getting lost) subtract the game in question against the team with which the formula originated with and get an average for the remaining total stats.

Is this possible to do? Is it possible to create a general function that I could copy/paste and make this work? Also, is there a character limit to functions? I fully expect this to get out of hand (if its possible).

Thanks!