Data Set of URLS

I have a data set of around 650 urls that I scraped from the internet. What I want to do is use these in something like FILENAME URL to scrape data from each of these individual web pages (I hope that makes sense). I don't know how to approach this. I've tried setting up a macro with a do loop and FILENAME URL inside of the do loop. But this doesn't seem to work. Any help would be appreciated. Thanks

I'm trying to gather data from an NBA website. The observations look similar to this:
Last edited: