Info update between sheets with multiple variables Macro or VLOOKUP Maybe?

Hello gentlemen,

I'd be eternally grateful if someone can help me out with what i'm hoping to accomplish.

Note the attached file "Team Sheet.xlsx"
Workbook contains sheets as follows:
Standings
Schedule
Matches
Top Gun

Please disregard Schedule and Top Gun sheets as they are not relevent for the potential goal.

Note on Sheet "Matches"
Each week 5 people play, another group of 5 people.
The group on the left will all be based off the 8 people listed on Sheet "Standings"

What I'm looking to do, and I hope I can explain it well enough.

I need either a VLOOKUP or a Macro that looks through column "B" on Matches for a player number. (this number correlates to Sheet "Standings")

Upon finding the player number on sheet Matches per week, I want it to update the lower table in Sheet "Standings" to increase the MP column (D) by 1 per specific player.

For example:
Search Matches.Range(B22:B26) for value 6265
If Value 6265 exists in mentioned range go to
Standings.Range(D24) increase by 1

Once we've verified that a player has participated in that week, i want it to take that same row, Matches Row 25 per example. and see what the value of Column E is, in this case 4. So being that the value is 4 to go back to Standings.Range(J24) increase by 1

Example Continued:
After found Value 6265 in Matches.Range(B22:B26) {exists in B25}
Verify value of E25 in this case 4
Go To Standings.Range(J24) increase by 1

Once we've increased the our second value, finally we need to check the Value of Matches.Range(D25) Per example. If Value of D25 is W then update Standings.Range(I24) increase 1. If the Value is L in Matches.Range(D25) then do not change the value of Standings.Range(I24)

Example Continued:
Upon Finding our player, and the value of E25,
Verify if player Won or Lossed (W/L) if W then update the Win Value
in Lower Table of Standings, if Lossed do Not change value.


Finally I need this same set up to be able to be repeated for all 8 players from Sheet Standings.

If it's better to have a macro button on the Standings page, that will run a macro to update the data, or it is a constant VLOOKUP

I'm trying to reduce the locations that require editing. My goals is that I only need to update the Matches sheet and that information will update the rest of the workbook.


If this is too extreme just tell me i'm dumb and i will move on.

Thank you for all who contribute.