How do I look up data on another workbook and copy across

Can anyone help.

I have a workbook which has 3 sheets named up/down/sheet 3. What im trying to is look in row 8 in sheets 1 and 2 for a unique code I.E 2H00 (up).

What I need to do then is to look in sheet 3 in column B for that unique code and then copy over the diagram no shown in A to the column concerned and put in row 66.

To explain better I have 2 workbooks called before and after and this shows better what I want.

Can anyone assist.

Thanks