Macro to Parse Text - Import text to Excel from Multiple Text Files & Folders

I want to run a macro, which will import Text (Required or All) from Many Text Files (.txt). Each Sub Folder in Directory has a Text File, which all are needed to be parsed to a common format.

On an average I generate 40 to 50 Text Files a Day and then open each one of them and copy to excel manually then processing the data manually, which is taking much of my time.

Text file has a data like

   SRR_NO   |SRR_STAT|      GEN_STR       
------------|--------|--------------------
    13765.06 CLO      71                  


ELT_NAME:
SDDR_3_4_3_4_RIGFLT_CSOL.DOC                                                    


   SRR_NO   |SRR_STAT|      GEN_STR       
------------|--------|--------------------
    12733.01 CLO      36                  


ELT_NAME:
SDDR_3_4_59_HSTA_POST_BRAKE.DOC

Which I process manually like this

Sn	File Name	ELT_NAME:	SRR_NO	SRR_STAT	GEN_STR
1	PROJ_MAINTENANCE_O	SDDR_3_4_3_4_RIGFLT_CSOL.DOC	13765.06	CLO	71
2	PROJ_MAINTENANCE_O	SDDR_3_4_59_HSTA_POST_BRAKE.DOC	12733.01	CLO	36
3	PROJ2_PRIMARY_O	SDDR_1_5_7_9_CSOL.DOC	98765.06	SEC	14
4	PROJ2_PRIMARY_O	SDDR_8_9_09_A_T_BKE.DOC	98763.01	CLO	67
5	PROJ2C_CORE_O	SDDR_8_1_4_1_FLT_CL.DOC	90765.06	VER	45
6	PROJ2C_CORE_O	SDDR_6_3_23_2_TA_PT_BR.DOC	9733.01	VER	87

Is there any way to do this through macro... Need your help in automating the parsing process. Attaching sample files (text file & manually processed file) for your reference...
Please help...

Thank you
Sample_File_Processed_(Done_Manually).xls
Sample_Text_File_PROJ_MAINTENANCE_O.txt