I am really green when it comes to VBA's and macros, so please bear with me.

What I am trying to do is take a column of URL's, create a macro that will open each URL, go to the area of the website that has the specific data that I need and return that data to the appropriate cell next to the collected URL. The URL is in this form =Hyperlink(L45&...)

Is it possible to do this?

Thanks for the help, I have been struggling with this all day!