You may well be able to webscrape it from internet explorer using vba, just depends on the setup of the web page.
I've never been able to be successful enough in vba I.E. webscraping to use it very widely, but on occasion, it works - depends on webpage source.
Investigate terms search like "vba read data from internet explorer"
Another creative idea is to see if Excel will download that active URL while it is open.
if excel downloads it in any intelligent layout, you can use vba to Refresh the Connection and look for new data in cells.
I did this once to keep tabs on new ads on Craigslist of a certain type, it was pretty cool and worked perfectly