Text file into excel sheet

[Mrchnexcel]

I have a requirement like,
2018 - Folder,
Inside - 201801 to 201812
Inside - 201801 I may have 0 to n number of .txt files.
I have copy the txt file data into excel sheet.
like that upto 201812

Example :

Inside 201801 I have 3 txt files then my output will be three sheets under single excel for that particular folder.

The txt file should be delimited by comma.

After successfully copied the txt file data into excel sheets. all txt files present in that folder should be auto delete.

And also a log file should generate with summary of processing details like,

Year Month of Year Number of txt files Number of excel sheets Excel sheet name Number of delete txt files.
2018 201801 10 10 XXXXX.xlsx 10
2018 201802 05 05 YYYYY.xlsx 05

so on.....