Merging files of 2 different folders Based on keyword

[SureshBurra1982]

I have 2 folders, both the folders will have same number of files. I need to merge the file(s) of folder2 with folder 1 file(sheet1 only) but need to identify the same files. 

Please find the naming convention of the files. Need to identify both folder files based on code(20,30,40,45, etc) 

Need to pick (ABC - 20 - XXXX) from folder 1 and find out 20  keyword contained file in folder 2, Merge the file of folder2 in file of folder 1 sheet1 . Same for all files in folder 1

Ex:

Folder1                                     Folder 2

ABC - 20 - XXXX                   Mop - 30 - mmyy

ADF - 30 - XXXX                   Mop - 40 - mmyy

QWE - 40 - XXX                    Mop - 20 - mmyy

[Qiu]

@SureshBurra1982 
Hope this is what you need.