Find result from different page for corresponding name

Hi, Little bit of help please.

In the attached workbook I require on the worksheet "Attendance" in Column B a formula that looks at the name in column A, finds it in column A in worksheet "Beds" and gives the corresponding result from Column D.

So for example the result I require in B2 (Attendance) is D73 (Beds).

Hope that makes sense. I'm guessing I need INDEX perhaps?

If somebody could give me the formula for B2 (Attendance) I should be able to do the rest.

Many thanks.

Try

=IFERROR(VLOOKUP($A2,INDIRECT("'" &B$1&"'!A15:D100"),4,0),"")

Copy across and down