Can anyone tell me an easy way to do the following:

I want to import to a spreadsheet a number of text files.

The spreadsheet has one column with the name of the text file (column A), and one column with the name of the folder it is contained within (column B).

Is there a macro that will read these files from within their respective folders and paste the data contained within into the next column (column C)

Eg macro would give C://[path to folder contained in column B]/[text file name from column A.txt] = output to column C of raw contents of text file from location.

I have about 13000 folders all with similarly named files within and cant do this manually!

Thank you