Importing TXT file from web
 

I have setup a list in MS Excel sheet as below:

in Column B
1 http://www.somewebsite.com/text1.txt
2 http://www.somewebsite.com/text2.txt
3 http://www.somewebsite.com/text3.txt

Now, I would like to import all the txt files in Excel either on seperate
sheets or single sheet. I tried the 'Import Text
File' option but its kind of repetative task and requires user inputs.

Can I do it through macro?

Thank you,
Murtaza