To read many text files and write it in the excel file

Hi everybody

I need help for reading data from text files and saving it under different columns in the excel file using vba macro.

For example: I have many text files in the following format

File 1:
1 2 3 4
1 3 5 7
1 3 1 8

File 2:
1 2 3 4
1 3 5 7
1 3 1 8

In excel file the above files should be saved one below the other seperated by the name of the text file, in seperate coumns as found in the text file.

I found an example online but it saves the data under a single column only. I tried changing it to my requirement, but I couldn't. I have attached the example that I found online.

Thanks
Bharath