Excel sheet VBA update

Hi,

I've got an Excel sheet created by a freelancer couple of years ago, which is now throwing up an error.

The sheet automatically populates data from two websites into the sheet:
1. https://fantasy.premierleague.com/
2. https://understat.com/

I need to rectify the error and optimise the code if possible.

Thanks,
Nurzhan.