Create an excel file with different sheets for each text file from different folder

Can't Post

hello,

I need code for the following scenario.

i have a folder TestResult which has sub folders (Test0, Test1, Test2,......so on). These sub folders has 1 log file each which I wanted to be copied in different sheets of one excel workbook. So all the log files will be the sheets in one workbook.