Want to fill multiple rows and columns by selecting drop down

I have never done VBA before, and i cant do this with just functions on excel.

Id like to select a drop down and have it fill in a table that has that value.
Example:
The drop down selection id like to do is: Tester type "120VAC" which is in my "BOM" tab.
when i select this id like it to look in my parts table, which is in my "tables" tab to find everything that has "120VAC" in the lookup column.
I would like it to fill out a table with those 16 rows with with 5 columns back on my "BOM" tab.

I am not sure if this is possible, and any help would be greatly appreciated!