Search through a specified workbook and return values from specified cells.

Hi all,
So my problem is I'm trying to write a VBA script that using the content of a cell specified in my script, the script searches through a specified workbook. Once it's found a matching value the script uses the found row number and using set column letters, the script returns the values of 2 cells to specified cell numbers in the active sheet.

What I have so far is a modded script I use to search through a folder and add hyperlinks to the relevant files. But I'm new to VBA so am a little lost.
Any help would be greatly appreciated.
THANK YOU

Hi again guys, Sorry I forgot to add the Workbooks that I'm working with.
I'm trying to take the value of cell E2 in book1, use the value as search criteria for book 2 to find a row number. Then using the found row number take the data from E? (found row) & F? (found row) and populate ActiveSheet D9 and F9.
Sorry if its not very clear, but I'm new to this forum.