Show multiple values from another sheet

Good morning all,
I have a workbook that contains customers on one sheet and then the products they ordered on another. Thats how the software exports it. Stupid I know. Some customers order multiple items so there are separate line items for each product they order on the order sheet.
I would like to get all the SKU's they ordered on the main customer sheet. I really dont know how to explain it any better so i have attached a workbook. The first sheet is called Orders and you can see the order# in A and then what they ordered is in in the sheet called OrderDetails in column E. Like i said some customers order up to 10 items which is why i want to show it going across instead of down like the sheet does.

Thanks for your help
E

i don't see customer names anywhere. are they there? is looks to me that you have to write code to do the consolidation.

I took the customers names out for confidential purposes. The lookup value would be the Order number in Column A on both sheets

How about.
In F2 copied down & across
=IFERROR(INDEX(OrderDetails!$E$2:$E$536,AGGREGATE(15,6,(ROW(OrderDetails!$E$2:$E$536)-ROW(OrderDetails!$E$2)+1)/(OrderDetails!$A$2:$A$536=$A2),COLUMNS($F2:F2))),"")

That works perfect. Thank you @Fluff13

You're welcome & thanks for the feedback.