VB Macro for Match Index
 

HI All,
I need your help to write a Macro which will match a string in all the
sheets and Index the corresponding values next to it.

Eg i have 4 sheets in a Workbook. in the sheet4 i have values

A1: 8001
A2:8002
A3:8003
....
....

and sheet1,sheet2,sheet3 as values like this

A1:7001 B1: Sold
A2:8002 B2:Not sold
A3:6005 B3: Not sold
....
....
....

Now in Sheet4, I want to search for values in range A:A(sheet4) in all the
other sheets in the workbook and Index the corresponding values in Range B:B.

I know how to use Match Index function, but i want to write a code what will
match the value in all the sheets in the workbook and retrieve the
corresponding value.

In addition to that.. I would also like to know the code snippet if i want
to run this code to retrieve values from other excel file and not from the
other sheets of the same file.

Hope I am able to express my query. Any help will be appreicated