Get gata from URLs in table

Hi 

Im looking to build a function that will run for each row of a table and get data from a website.

The URL will be concatenated in a column in a table but I want to then pull info from the website into the table next to it (or a seperate table if needed).

So the table would look something like this

Then I would want, probably a function, that calls the get web data for each row.

Any redirects to some good examples would be great

Cheers