Lookup from multiple columns and automatically add additional rows if multiple values

Hi,

Not sure if this should be a macro although a straight formula is ideal. I have a sheet (Sheet1)with a master listing of all my customers(Col A), and then what type of product they need throughout the year (Col B-D).

On a separate sheet (Sheet2) I have our current order list by customer (Col A). If the customer is selected for only one product on Sheet1, that value should be listed on Sheet2 in Col B, however if they are selected for 2 products, ideally it would create a new line, duplicating the customer name(Col A) and add the second product (Col B), ditto for 3 products.

Any thoughts?