28311 Excel Macro

In Excel, I have a list of 750 names that have individual links. The links take the user to a web page that displays the individuals address. I want to copy/paste the address of each one into the excel file. I tried to write a macro, but it only selects the specific link that was selected when I was recording and I can't figure how to have it go down the list on the spread sheet and select each specific link. I can go thru the exercise and click on the link, copy the address, and paste the address. But this is taking too long and it vary tedioius. I attached an example of the Excel file with 3 links. Good Luck!