I need to get data from multi Web Pages from a website.
Web pages are in a order from 190001 to 390300 like its URL

http://example.com/example.aspx?sid=194746

This 190001 continues like 190001..190002.........390300

How can I get this data from this WebSite?

And of course data is very big. (aprox.200K pages)
I want to get this data , as worksheets like "190001", "190002"......
One workbook can be limited as 100 or 200 pages.

Thanks in advance for any reply and help.
Regards,
turist