How about loading them into PowerQuery and then loading into Excel. You could have a table of URLs in Excel that you use as the source for a base query that then gets the rest.
Yes, as a starting point, see attached.
p45cal Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.