Open file path from cell, paste into new sheet named from another cell and loop

Hi,

I'm a fairly basic user of VBA and have found this forum enormously useful over the years. Invariably there's already some code posted somewhere that I can find and modify to suit my needs, but this time I'm drawing a blank.

I need some VBA code to open a text file (they are text files with a *.WTS suffix, but they are text files and excel can open/import/read them no problem) and paste the contents of that text file into a new work sheet in the workbook and then loop through 225 files listed in the worksheet. I currently have a sheet in a workbook in which column A contains all of the file paths for all the files and column B contains the corresponding sheet name which I would like to apply to a new sheet into which the contents of each txt file are pasted.

I imagine this is pretty simple stuff - but I'm hitting a complete block trying to get something that even begins to work. Could anyone lend a hand?