pull data from a table by inputting 1 entry

[baker1999]

I have a product with associated parts table. Each line is a part which is associated with a product. I want to be able to enter the product SKU (on a different sheet of the workbook) and have all of the associated parts populate from the table. I've attached a snippet of the table

I try to google things but I can't seem to come up with the right wording to find out how to do this.

Capture.PNG

[JohnTopley]

Please see yellow banner on how to attach a sample workbook: ensure expected results are included.