return all range based on criteria

I need a formula that will, with certain criteria to copy data from another worksheet.
I have two options
The first option data is available in multiple columns
The second option, the data contained in one column

Can someone solve this problem but with the formula, if possible to avoid VBA.
Please see Attachment, Thanks

Hello Dumy,

See the attached.

Originally Posted by Haseeb A

See the attached.

Haseeb, this is it
Thank you

edit:
Haseeb A, Can you explain this formula of words

Please Login or Register  to view this content.