Formula to copy text from a different sheet with a condition

[skylinekiller]

I have 2 worksheets from 2 separate workbooks. For this question I will say Workbook 1 and worksheet 1 is called WB1 and WS1, the other is WB2 and WS2.

On WB2, WS2, I want it to extrapolate row information from WB1, WS1 if it contains the word DV in Column A2-A117. I want it to pull info from rows B,C,D,F

So if on WB1, WS1 has row 32 with the word "DV" in A32, my WB2,WS2 formula will have the info from B32,C32,D32,F32.

Can someone help me with this request?

 

[SpillerBD]

IF you weren't omitting a column, we would use the Advanced Filter feature and its Copy results to new location.
Since you are eliminating columns, we would use the query feature now called Get and Transform.

This Microsoft page, includes some tutorials.