I have a workbook that other folks "update", but I need to pull over some of
the data from that workbook. My problem is:

In workbook A, user will update key columns.

In workbook B, I need to pull in data from workbook A, but they must line up
with the data in book B.

In Workbook B, I need to:
Check A2:A50 for a value,
Find that value in Workbook a, sheet a
Once it finds the value, pull in the value under columns AX and Bx in to
the workbook B.

I need to do this for each value in A2:A50. Workbook A, will only ever have
1 occurence of any value in A2:A50, but may not have all the values in A2:A50

Any ideas? I don't even know where to start!

KSL