Linking multiple columns to populate on a separate worksheet

Linking multiple columns to populate on a separate worksheet. I have created a worksheet where I have a drop down box for customers and I need the customer specific tests to populate in the table when that customer is selected. If there is no test or specification for that customer. I need for the the cells to remain blank. Also some of the customers have more then one test that needs to populate in the table when chosen. PLEASE HELP IF POSSIBLE