Football (soccer) league table help request

Hi

I need help creating a spreadsheet where I enter scores at a football tournament that will automatically update a league table please. I have attached a dummy version of what I'm looking for and the first tab (tagged as manual) is what I want to get to but with automation. Not sure if this is a vlookup thing, index or what so any advice is greatly received

Thanks