how to use get data option in excel for multiple urls?

I have a list of website URLs in one column lets say A1 to A704

In this format:

www.website.com/page=1
www.website.com/page=2
www.website.com/page=3
www.website.com/page=4

etc.....to page 704

I want the excel web query command to extract and import the text fr开发者_JAVA百科om each page and then paste it in ONE new sheet in one column, with each page after one another so....

Page 1 Text extract

Page 2 Text extract

Page 3 Text extract

etc

How would I do this?

You'll need to build a macro to do so. How familiar are you with VBA?

Check out the answer to this question: VB6 Download Web Page Source