Combine data from multiple excel workbooks in a folder into one master file

I use Office 365 Hello,   Please note that I made few changes to the criteria and the files that correspond to the new changes.   I need help with VBA code that need to perform the below: There...