Hi I need a macro that can filter & copy the rows after checking 3 criteria (3 column combinations) from the master file.

These rows will be available in any of the 3 Customer Folders with the file name that is matching the unique product id.

Eg :

Col A is the unique customer ID. Col B is the name of the agent dealing with it. Col C is the answer if the customer has agreed to the agent request. Col D is the concatenation of all these 3 column items. The concatenated column text is to be searched in the folder of the 3 customers (Folder names -> ABC, DEF, XYZ). The file names could be the name of the product id's. All three customer folders may contain or may not contain the excel files with the product id. The excel workbooks should be searched in the above customer folders using the customer ID in col A and if found, search for the sheet name as containing in Col D. and if found, extract the data from that sheet and paste the data in the sheet next to the main sheet. If not found, mention the message in the Col D as stated below.

Master sheet

Col A - Col B - Col C - Col D - Col E
546764 - AN - YES - 546764ANYES - If found "Found in folder" Or "not found in the folder"
467545 - BK - NO - 467545BKNO - If found "Found in folder" Or "not found in the folder"
345678 - JD - YES - 345678JDYES - If d