Where did you get the WHO data
https://covid19.who.int/Look underneath the map and there is a link in small blue type "Download Map Data". It will give you a 13,000 row CSV spreadsheet.
Programming the spreadsheet to update automatically is beyond my Excel capabilities. i may be an Excel God among some of my less techie friends because I can do complex formulas, VLookups, conditional formatting etc. (all of which are used in this spreadsheet BTW) but compared to a lot of people (yes, you, Christian!) I'm not even in the rank amateur category.
However, it takes me less than 15 seconds to update the spreadsheet once I have downloaded the CSV file. Open the file, copy it to the clipboard, paste it into cell A3 of the spreadsheet to overwrite the existing data, and its done.
tanstaafl.