Extract data from website to excel?

Hi all dears It's 3rd week that I am trying to extract some data from website to excel : Some lists of data are split into multiple pages. Example: 100000 entries are displayed on 1000 pages, 100 per page. I want to extract the data WITHOUT having click the Next button and manually saving each set of... show more Hi all dears

It's 3rd week that I am trying to extract some data from website to excel :
Some lists of data are split into multiple pages. Example: 100000 entries are displayed on 1000 pages, 100 per page. I want to extract the data WITHOUT having click the Next button and manually saving each set of data.How to create formulas to extract data from a website and input into an Excel 2010 worksheet?
website has some repeated part
name :
phone number:
Address:
Code :
etc.
2 answers 2