Linking WorkBooks Based on Data Entered In One of Them
 

I have two WorkBooks. In WorkBook 'A', there is a field called 'keyfield1'.
In all other Workbooks in the same directory, there is a field called
'keyfield2'. I need to be able to enter a value in keyfield1, then based on
that value, search through all WorkBooks (in the same file directory) for the
same value in keyfield2, and use that relationship to link the unique
Workbook that contains that value.

1) Can I do this without VB programming? How?
2) If I need to use VB, is there a script anywhere I can use to begin with?
(I am not a VB programmer.)

Thank you.
George