I have setup a list in MS Excel file as below

Column B
http://www.somewebsite.com/text1.txt
http://www.somewebsite.com/text2.txt
http://www.somewebsite.com/text3.txt

Now, I would like to import all the files in Excel. I tried the 'Import Text
File' option but its kind of repetative task and requires user inputs.

Can I do it through macro? like a Macro import the files in single excel
sheet


Thank you,
Murtaza