Linking of multiple excel workbooks using VBA

[nandu6630]

Would appreciate your immediate help pls.

I have 3 excel files.
First excel has values in cells E2,E3,E4 etc. (For example customer no: say AA12, BB122, etc...)

Second excel has 5-6 sheets, corresponding to work centers, where day to day data & operation details corresponding to all customer are given say PO no, contact details, activities etc. Against, each line of record, there will be a cell which contains a pdf file (hyperlinked)

Say (Sheet 1)
Date PO Cust Contact Activity Activity No
dd-mm-yy 999SSss AA12 djdjd@fhfhf.com Quote open 22224
dd-mm-yy 235223 BB122 doadh@ajk.com Bid 325235
dd-mm-yy 4149134 AA12 jkhk@hkfjaj.com Closure 14414
dd-mm-yy 41486146 AA12,BB122 iosdku@fah.com Purchased 124144

Pls note activity common for 2 customer nos.

Sheets 2-6, will also have similar data.

Now I need a third file, where when I specify the customer no, the macro should open the second file & then start searching for all records matching to that customer no (in 5-6 sheets) and start copying matching records to 3rd excel. It shall sort the values by means of operation no or so (range A5 in all 5-6 sheets)

3rd excel should look like; For AA12

ddmmyy 41486146 AA12 iosdku@fah.com Purchased 124144
ddmmyy 4149134 AA12 jkhk@hkfjaj.com Closure 14414
ddmmyy 999SSss AA12 djdjd@fhfhf.com Quote open 22224

Activity common for 2 customer nos; shall also be reported however with 1 customer detail in 3rd excel.

How do I do this using excel VBA