Formula required for list creation within worksheet

[the frost]

Hi,

I am trying to integrate the attached style file into a larger workbook. This worksheet would populate a list of components against each selection I make. I have tried multiple formulas using match and indexing but can't seem to make them work!! essentially the part of the sheet is used to generate component parts from product selection to create a shopping list and also a unique list to apply rates too. If I can get this bit working I'm fine with the rest.

I have created a sheet free from formula with the view of the following:

Ideally, I would like to be able to add new selections and the parts that come with them to the "data" tab
The ideal display is how I would want the sheet to appear in my master file.
finally, I would like to be able to generate a unique list on the "list" tab. This would list all parts shown on the "ideal display" tab without duplicates.

please can you help me!

[Glenn Kennedy]

This is identical to yesterday's thread. Please refer to the forum rules. One thread per topic only. I am closing this thread, now. As you have had no replies to your previosu thread, I suggest that you bump it to the top of the list again by replying to it yourself.... asking afresh for help, IN YOUR ORIGINAL THREAD.