I need to read the contents of 100 or more log files into a worksheet.

Each file is named differently (7 digit number). All are contained in the same folder.

Each file contains a set of information in a single column.

I would like to copy that information into a speadsheet so that the contents of the first file are placed in the first column, second sheet into the second column.

Now I can read a single file into the first column and assume I just need a loop to increment there the data starts but its the reading the second file name onwards im having an issue with.

I could probably use the "dir /B /O:N >list.text" function at the DOS prompt to generate the files to read but not sure if this is the way forward.

Has anyone done somethng like this before? I cant imagine this is anything out of the ordinary but have Googled until my fingers bled and found nothing that fits.

Any assistance you can offer would be much appreciated.