vba function vlookup through 2 closed workbooks

dear experts

I need help on this either on worksheet function or vba command .

i have one master and two workbook in particular path...
\\10.50.10.86\lenovo\OPEN CALL\SEPTEMBER\12-SEP-2013\SLC'S\A.xlsx
\\10.50.10.86\lenovo\OPEN CALL\SEPTEMBER\12-SEP-2013\SLC'S\B.xlsx

some times i am not able to access path so i want pull data from path of two file.. A&B.xls

I want vlookup worksheet function to pull data of updates in A& B Which i stored file in

lookup_value, is my master sheet A:A
table_array is RANGE IS OPENCALL!A:G
col_index_no is 3,4,5,67.
FALSE

once i enter data in working files in master cmd button run code thorugh closed workbook get updates from 2 workbook...A:G as per A column values.
help me on this how to easiest way to get updates from closed workbook