Hi,
I have data in a Summary Sheet column A (about 1000 rows) and several other
sheets with some of the same data. I need to find the first match in the the
other sheets and place what is in column B next to the same found data in
the summery sheets.

Summary
A...........B
FA
VB
EG


sheet1
A............B
EG...........4
FA...........10


Sheet2
A............B
VB...........5
EG
FA


Result in Summery after running the macro
A............B
FA...........10
VB...........5
EG...........4


Thank you for your help
Andonny