How do I sort/rank multiple different text values across variable rows and columns in separate workbooks?

I have a workbook with the following properties (please see this example):

• most fields are text

• seasons are in separate sheets (ignore the example), games are in different columns, and players are in rows

• the number of players varied in each season and game

• some players played across multiple seasons and games

• some players played the same game multiple times in each season

• some players played in no seasons or games

Variables (I think?) in the example:

• season number (Season1 - Season2)
• game name (Game1 - Game5)
• player name (Player1 - Player10)
• points won (1 - 10)
• result (1st - 3rd)

What I need to do:

• use the simplest way to find the top 3 players per season, based on the number of points they won in each game

What I've tried:

• mostly this

• random COUNTIF/SORTBY/VLOOKUP formulas I tried making up

• searching Google, Reddit, and Microsoft

Ideas:

• use different functions

• make a better algorithm

• make an array

• use a script

I learnt programming and was fairly competent with using excel over a decade ago, but unfortunately I've forgotten most of it and have ended up confusing myself.

I'm currently using Excel for Microsoft 365 MSO installed on Windows 10, but can also access the web version. I could also try to find my copy of Excel 2019 if need be.

Is anyone able to help? Also I'm sorry if the title is wrong!