Export data with two Criteria values from closed workbook to closed workbooks VBA

Export data with two Criteria values from closed workbook to closed workbooks

Dear experts

I have Master file Export.xlsb workbook saved In Path: and I have saved multiple file Another Path.

I want export only two set of data to particular two files

In Export.xlsb Sheet[Wrap] Column B consistent multiple partner name i want copy two criteria data's CAMERON CRD & CAMERON USD paste into two workbook which in folder contains multiple workbook list path.

CAMERON CRD move to Rpt_CAM_JAN.Xlsb but one complicated task is Rpt_CAM_month get change everytime.Xlsb
CAMERON USD move to Rpt_CAM USD_JAN.xlsb but one complicated task is Rpt_CAM_month get change everytime.Xlsb

Create only Macrofile run code from the file , copy value from exportxlsb paste to two workbook

find the attachment

any expert help on this? feel to close thread with out solve