Control Box and Index

[Henry]

Hi: Let me see if i can explain this w/ot cause mass confusion. I am using Control Box, the one with drop down selection capability. I have a in A1 thru A10, meaning 10 boxes. The data that comprises the box is in a 2nd worksheet titled data. Each DD allows the customer to select from 150 different names. Each box has 150 names to choose from. So, once the customer selects 10 names, which in turn are placed in each respective cell using Index (same data worksheet), I then used Concatenate and pull all 10 names into one large cell. So A1 thru A10, using Control Box is tied to Index which in turns places the chose name in cells A1-A1-. Then I Concatenate A1-A10 into B1. Does this make sense. The real problem, besides mass inefficiencies, is I have to have 10 cocmplete sets of names (10 x 150) just to get the info into B1. Isn't there a cheaper, better, faster way of getting this done. My current method means lots and lots of data on my Data WS. Thanks Again.