Multiple URL and data extraction

[gabspagnoli]

Hi guys/girls,
I’m a newbie and this is my first post.
Thanks for accepting.
Hi have the following needs and I’m quite stuck since I know only basics of VBA, but I think this is an easy question for most of you:
I need to extract data from a website, the URL is the following
Dettaglio della Ricerca=
after = there are several pages, let’s say 218341, 218342, 218343, 218344, etc.
Basically the URL where data is contained is:
https://servizi.ivass.it/RuirPubblica/DetailResult.faces?id=218341
Dettaglio della Ricerca
Dettaglio della Ricerca
Dettaglio della Ricerca
The amount of rows could be very high, likely around 180.000.
Can you help me setting up a working macro + vba code which includes a loop on all this URLs?
The final result is more similar to a web scraping tool.
Best regards,
Gabriel