Hi there,
I'm not well versed in excel but what you require is likely not doable with it solely. Though I haven't checked it throughly yet, fetching data from axs will not be that easy. There's probably cookie checks and all sorts of stuff to prevent scraping in place. I searched for an API to get the structured data but it seems like they don't provide access in an automated fashion like the other sites. Instead they require you to send email for access tokens to some developer. Then he'd provide you these tokens based on some criteria. It might be some sort of partner thing and not available to public at all.
Per the documentation, jsonp access is disabled for the site as well which in return makes it impossible to use javascript to fetch data. Only viable option left here is using a server side language like php, python or something else. Fetching the data with one of these langs and populating an excel file per your specific queries might be a good solution. Anyway I'm just wildly guessing here for a solution since you haven't disclosed any details. If you share more about your workflow I'd understand the situation better thus offer more specific solutions.
p.s In this regard my current bid is a placeholder and subject to change.
Thanks
Ibrahim