Fetch data from another sheet based on a filter value

Hi All,

I have run into a simple problem which I am not able to comprehend. Can someone please help me this.

In one of the workbooks, I have data on one sheet with different columns. Now on another sheet inside the same workbook, I have created a dropdown list, using one of the columns from my data sheet. I want to fetch all the records from my data sheet whenever a person selects a particular value in the dropdown list. Can some one please help me with this?
I have attached the sample worksheet here.

Thanks so much for your help.

I could use a simple vlookup if there was only one record per select value. But my problem comes when we have multiple record. For example, in the sample sheet Supplier Dave has 2 parts. And I shall want to fetch both of them.

Cross posted here