I have multiple text files in one folder.
I want to import them all onto one worksheet, with the entire contents of each text file in its own column.
(So, text file 1 goes in Column A, text file 2 goes in Column B, etc.)
If it could be updated each time I add a new text file, all the better...