Searching throughout multiple sheets and returning values between multiple workbooks

[AmraEx]

Hello,

I would appreciate any help with following.

I have two excel workbooks, both containing multiple worksheets. I need to do following:
- search the excel workbook 1 for a text from workbook 2
- when it is found - return a value from a specific cell in the sheet in workbook 1 (sheet that contains anywhere in it text from workbook 2) to specific cell in workbook 2

Thank you