Create a tally of point accumulation based on finishing positions in multiple tournaments

Hi folks. Here's a rundown of what I'm trying to achieve:
Imagine a Chess championship, run across a country. Let's choose Australia for example.
There are 6 tournaments, followed by a 'grand final' between the top 4 competitors (based on accumulated points) at the end of the year.
Allocating points would be easy enough with a formula, but I'm hoping to have the points automatically allocated to a person's name determined by which cell it sits in.
For example, John is 1st in Perth, netting himself 100 points (as a standard event), and also 1st in Sydney, gaining 160 points (major event). So those figures and all other results will come across into a tally in another column, preferably in order of total points by player, highest to lowest. From there a grand finals can be auto-populated with simple A=B formulas.

Any help would be much appreciated, I figure it might not be possible with regular formulas (??) and needs VBA macros, which I'm no expert at using...
The main function is to give a cell a value for the name I input, eg, B3 allocates 100 points to whichever name appears in it. Hope that makes sense.


tournament example jpeg.png


tournament example.xlsx