Formula for customer purchase consolidation

I have simplified this for the sake of getting my point across!
I have two sheets
1. contains customer orders across time (all orders)
2. contains customer information.

I want a formula that returns all the products purchased by a customer over time in the 2nd sheet.

Below is an example of a simplified version of the two sheets.
in Sheet 2, next to Jones, I want a formula that returns all the products purchased by Jones. (and then so on for Smith, Doe and Bailey as well)
bonus points if it can exclude duplicates.

so, if the formula worked, in "Products Ordered" on Sheet 2, next to Jones, it would say "blue, yellow, black, green, red"

HELP?????

Me thinks you would need to use a VBA Macro to accomplish this. With VBA you can step through each row looking for "Jones" in the first column. When found, you step through each Product value (column) concatenating them together until you reach a blank. Then you move onto the next row, then the next, etc. Not really that difficult if you know what you're doing, but time consuming, nonetheless... I don't think there are any formulas in Excel that do this for you, unfortunately.