Need Help With Multiple Download Macro

Hi,

I am trying to download web pages using Data, Import External Data in Excel 2003.

I have this -

Please Login or Register  to view this content.

I need to do this for several hundred url's is there a way I could run this bit

Please Login or Register  to view this content.

separate from this bit

Please Login or Register  to view this content.

My thinking being if i had a list of urls the macro could go to the next and get the information and then paste it to sheet 2 and then the next and paste to sheet 3 and so on. I just don't know how to go about it.

try this..

let me know if this works.

Please Login or Register  to view this content.