I have a column of =hyperlinks. I'd like to have a macro that uses "Get External Data" and usese the =hyperlinks in my spreadsheet instead of a manual input of the URL. Then bring back the selected table on the website to the cell next to the hyperlink in my spreadsheet.

Thoughts?