filter and copy data from different file to one excel using vba

[thomsonreuters]

Hi

I want to filter the data from each file and consolidate in to single excel my file name, sheet name and filter criteria are mention in column B, C and D. want to maintain same order based on filter creteria.

e.g:
Below table present in current sheet and needs to consolidate in the active sheet number 3

Can anyone pls help on this...urgent one....

thanks
JP

FIle name - Column B	Sheet name - Column C	Filter criteria - - Column D
PB3-ALL-20_SAVIG.xlsx	SAVIG QC Checked	WO2020060735
PB3-ALL-20_KPUSH.xlsx	KPUSH QC Checked	US2020095665
PB3-ALL-KIRAN.xlsx	SAVIG QC Checked	US2020094354
PB3-ALL-20_SAVIG.xlsx	SAVIG QC Checked	US2020098496
PB3-ALL-20_KPUSH.xlsx	KPUSH QC Checked	US2020098497

 

[Fluff]

Duplicate Want to open specific file, filter, copy and paste based on value mention in the specific columns...filter value should be in same order

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).