Formula to search multiple sheets and return specific cells from the matched row

Good Morning,

I can usually figure out my formulas between reading, experimenting and web examples but Im stuck on this one.

I want to use data in column B of Master, to search all other worksheets for a match.
If a match is found, I want to return the data in cells Bx, Dx, Ex, from the matched row. where x = the row number of the match.
If not matched on any sheet, populate with "no match found"

I have shown the result I'm trying to reach on Master in highlighted red.

Thanks alot for the help !!