VBA to apply vlookup formula in closed workbooks in path from ref of active wb

Dear experts

I have saved multiple workbooks in path i want fill vlookup formula in column p:p from range ref of active workbook

in wb master sheet Ref A:B range consider table array and column number is 2 lookup value is all closedworkbooks G2

find the attachment

any experts help on my thread!!