Poulate a cell in one workbook with data from a variable row in another workbook

Hi everyone.

I'd greatly appreciate any help that anyone may be able to afford a total newcomer!

My problem is this:

I'd like to populate the data in a cell in one workbook with data from a fixed column of a variable row in another workbook.

So I have workbook 1:
1.JPG


And I have another workbook (workbook 2):
WOR3.JPG



Now, in cell D2 , I'd like to populate data from workbook 1 cell B4. However - the row that the data (Beth's data) appears in within workbook 1 varies - so some weeks, Beth's data will be in row 4, some weeks row 6, some weeks row 36! - this is because the different people in workbook 1 will vary day to day/week to week, etc. (in truth - the data in workbook 1 is exported from a piece of software and I have no controlover the number of rows that will appear or of what row any given person will be on)

So what I really need is a way to tell workbook 2, cell D2 to find data from workbook 1, column D and whatever row contains the value 'Beth' in column B.

Is this even possible?

Many thanks for any help

Awesome, many thanks for your help JBeaucaire- I've learnt how to use vlookup and it's the perfect solution to my problem. Thanks again