VBA to get custom data in excel. : I want to get data from this website into excel. website: http://smsprank.ga/true/pro.php?no=62390012XX (replace xx with number)

https://ibb.co/bFgtF9-

I can do this in excel by data>from website. but I want to get 100s of numbers or URL which I have in excel, how do I automate this in excel VBA? 

