one formula to pull all the information from sheet 1 to sheet 2

I am back after a long time with a tricky question

I have a spreadsheet in which sheet 1 has certain data s and sheet 2 with certain numbers.

Now i want a formula in the sheet 2 which pulls up the information from the sheet 1 for the reference number listed in the sheet 2.

I just need the information available in the column B,D and E and if the reference number in sheet 2 is not available in the sheet 1 i need NA

I actually tried VLOOKUP, but it pulls only set of info's and I have to put 3 vlook ups to pull data s.

So please give me one formula which pulls all the 3 info I required.

Thank You so much for all ur help
attaching the spreadsheet for your reference