VBA Code to Pull out the data from the closed workbook

Hello Everyone,

I need to fetch out the data basis on some criteria's from the closed workbook. As I know it's possible only through VBA code. Explaining with an example;

Pull out the data in "Sheet1", Column D basis on criteria's in Column A, B & C from "Sheet2" (multiple tabs). Hope I'm able to explain. Can anyone in the forum please help me out. I am scratching my head from the morning but not been able to resolve it. Attaching the sheets for your reference.

Many Thanks in Advance.

Best Regards,
Abhishek