AutoPopulate a table based on a drop down lis

I have defined a drop down menu list and I am trying to get microsoft excel to auto populate a table/form to enable one to input some data.

For eg: If Drop Down list contains elements: (Preparation, Marination, Cooking, Garnishing)

I click on Preparation and I want excel to Auto Generate a table (5 rows) for the following items (each element within <> refers to an adjoining column)

Ingredients
<s.n.> <name of ingredient> <units> <Measure>

If some one could help me with a solution, it would be well appreciated