search text within a cell and vlookup

Hi

This is my first post.
Apologies if I am being dumb.

I just need a formula which can search in a table for "CSH" and do a lookup of the data in that row
I mean: I want to search for cell that contains text "CSH" in Column D and vlookup all the data in that row in another sheet

I have attached the excel sheet for your reference
Below is the screenshot as well
Untitled.png

Is there a formula which can do a vlookup accordingly?

Thank you