Creating one workbook out of many workbooks

Hi,

I need to create one workbook that consists of many workbooks (each have several worksheets) and combine them all into one workbook. They are all in one folder. However I only need those worksheets which name contains the following name ...MSCL.... But some letters may be before as well as after that string and my files are in each of the excel format: ".xls", ".xlsm" and "xlsx"

Directory for my folder is C:\Users\pllmkd\Desktop\VIN MAZDA\M3\M3 old

Could you please help me on this matter?

Thank you in advance.