Combo Box to create Lot Codes

[smlevron]

I have a worksheet created where the data to create a lot code is stored (worksheet 4). Our lot codes are a combination of plant code, day code (julian date), year code, product code, load number. So for example A208NR1, A208NR2, etc... With that said I have created a list of all the various product types and the possible load counts to select from (worksheet5 cells A10:A50); the load counts are each exclusive to that product, and it is my intention to use this list to populate the combo box list... What I don't know how to do is to tie it all together... If they select product L load 1, the lot code is A208N1... If they select product T load 5, the lot code is A208NT5.... If they select product R load 5, the lot code is A208NR5....etc etc