Add rows to a list based on cell value and key data

I'm looking for some help from all you Excel/VBA experts out there... This is above my excel knowledge...
I have attached my file and a screenshot to help facilitate the explanation of what I am trying to acomplish.

Excel Screenshot.jpg

The data in the list is a manually entered example of how I would like it to end up, automatically.

The pale yellow shaded cells are the only ones where data will be changed manually.

Cell B:4 is the key data for Column B

Cell C:4 is the key data for Column C

Cell E:4 is the key data for Column E

The pale yellow shaded cells in Column J should determine how many rows of that dataset type will be created in the list which would include the text of Column H of the same row being added to the D cell of each of the rows created.

Looking at the example you can see what I mean....

Thank you...... and I really mean that.... thank you for any help you can give me.