Hello!
Should it be a macro for Windows or macOS version of MS Office or a cross-platform macro?
Anyway, I'll be happy to help you as this work fits my developer skills.
I have vast experience in MS Office VBA development, have been coding in VBA for 15 years.
During that time I wrote many different VBA applications (please see examples of the macros in my portfolio).
Among them, there were a lot of macros that pulled data from web sources.
I will start immediately and write this macro in 1 day.
Hire me, and you'll get high-quality, robust, and well-commented VBA code, following the best programming practices.
Looking forward to your response.