Does anyone have any suggestions on how to create a macro to complete
following tasks?

There is a list of numbers under the spreadsheet Lists on column A, such as
1 in cell A1
3 in cell A2
....

[Creating a spreadsheet under specific name if required]
For the first numer from the list, if there is no spreadsheet named under
"1", then it will automatically create a spreadsheet named "1", which name is
retrieved from the list.

[Generating a query for connection before loading]
I would like to load the text from http://www.question.com/1.html into "1"
spreadsheet, the number 1 is retrieved from the list before inserting the
query 1.html. If the number is 3, the 3 will be inserted into query 3.html,
and all text will be load from http://www.question.com/3.html.

[Next number until the end of the list]
After completing the task for the number 1 in cell A1, then the next task
for the number 3 in cell A2 will be run until the end of list.

Does anyone have any suggestions on how to do it in excel?
Thank anyone very much for any suggestions
Eric