Excel 2007 : Insert list based on drop down choice

I would like to list items based on a drop down choice. I've tried several methods and can't seem to find the right solution. Any help would be greatly appreciated. I have attached an example of what I'm trying to do.
Thanks.

Hi,

see the attached. I inserted a few rows on your data sheet to make each block 8 rows exactly and inserted a blank in the seemingly empty cells
Then I assigned range names to each block, i.e. "Adjustment", "Blend", etc.

then in the Enter Data sheet I put this multi cell array formula in cells C9 to C16

=IF(B9="other","",INDIRECT($B$9))

You must select cells C9 to C16, and with this selection active enter the formula in C9 and then confirm with CTRL-SHIFT-ENTER

On the Data sheet keep the blocks for each type the same size as the block of cells where the text will appear. I think your dummy data will be extended, so I defined each block with 8 rows, although currently the maximum use is only 6 rows.

hth