Conditional Linking of Data from Different Workbook/Sheets

[redz06vette]

Good Morning All,

I have 2 workbooks, "Master" and "Data". I am trying to link info from "Data" to "Master" based off of an "Equipment #" (A1:A5). I would like to be able to search through multiple sheets (up to 100) in the "Data" workbook and find said "Equipment #" (located on B3 of every sheet). Once this has been located it would be able to link data (in F7, "Data") to a cell (B1:B5) in the "Master" workbook.
I have an example created with desired results if needed.

I GREATLY appreciate everyone's time and help with this one! Thank you!

 

[redz06vette]

Can anyone help me please??

 

[redz06vette]

Any ideas? Thank you...