Return non-blank cells based on drop-down--Excel 2010

[j_harrison]

High-level, I'm trying to bring in non-blank cells for a given product selected from a drop-down menu.

I have multiple "category tabs"--cakes, cookies and main dishes. I have created 2 drop-down menus: 1 for the tab name and one for the recipes within each tab.

Each tab is set-up similar to the following:
[TABLE="class: grid, width: 406"]
<tbody>[TR]
[TD][/TD]
[TD]Chocolate[/TD]
[TD]Carrot[/TD]
[/TR]
[TR]
[TD]Flour[/TD]
[TD]1 3/4 Cups[/TD]
[TD]2 Cups[/TD]
[/TR]
[TR]
[TD]White Sugar[/TD]
[TD]2 Cups[/TD]
[TD]1 1/2 Cups[/TD]
[/TR]
[TR]
[TD]Cocoa Powder[/TD]
[TD]3/4 Cups[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Baking Soda[/TD]
[TD]2 tsp[/TD]
[TD]2 tsp[/TD]
[/TR]
[TR]
[TD]Baking Powder[/TD]
[TD]1 tsp[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Salt[/TD]
[TD]1 tsp[/TD]
[TD]1/4 tsp[/TD]
[/TR]
[TR]
[TD]Buttermilk[/TD]
[TD]1 Cup[/TD]
[TD]3/4 Cup[/TD]
[/TR]
[TR]
[TD]Vegetable Oil[/TD]
[TD]1/2 Cup[/TD]
[TD]3/4 Cup[/TD]
[/TR]
[TR]
[TD]Eggs[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Vanilla[/TD]
[TD]1 tsp[/TD]
[TD]2 tsp[/TD]
[/TR]
[TR]
[TD]Cinnamon[/TD]
[TD][/TD]
[TD]2 tsp[/TD]
[/TR]
[TR]
[TD]Shredded carrots[/TD]
[TD][/TD]
[TD]2 Cups[/TD]
[/TR]
[TR]
[TD]Coconut[/TD]
[TD][/TD]
[TD]1 Cup flaked[/TD]
[/TR]
[TR]
[TD]Walnuts[/TD]
[TD][/TD]
[TD]1 Cup Chopped[/TD]
[/TR]
[TR]
[TD]Pineapple (crushed)[/TD]
[TD][/TD]
[TD]8 oz[/TD]
[/TR]
[TR]
[TD]Raisins[/TD]
[TD][/TD]
[TD]1 Cup[/TD]
[/TR]
</tbody>[/TABLE]


What I'm hoping to do (without using VBA if possible) is bring in the ingredients in one column and the quantity in the other but only for the non-blank cells. So if cakes and carrot were selected, the output would look like this:

[TABLE="class: grid, width: 286"]
<tbody>[TR]
[TD]Flour[/TD]
[TD]2 Cups[/TD]
[/TR]
[TR]
[TD]White Sugar[/TD]
[TD]1 1/2 Cups[/TD]
[/TR]
[TR]
[TD]Baking Soda[/TD]
[TD]2 tsp[/TD]
[/TR]
[TR]
[TD]Salt[/TD]
[TD]1/4 tsp[/TD]
[/TR]
[TR]
[TD]Buttermilk[/TD]
[TD]3/4 Cup[/TD]
[/TR]
[TR]
[TD]Vegetable Oil[/TD]
[TD]3/4 Cup[/TD]
[/TR]
[TR]
[TD]Eggs[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Vanilla[/TD]
[TD]2 tsp[/TD]
[/TR]
[TR]
[TD]Cinnamon[/TD]
[TD]2 tsp[/TD]
[/TR]
[TR]
[TD]Shredded carrots[/TD]
[TD]2 Cups[/TD]
[/TR]
[TR]
[TD]Coconut[/TD]
[TD]1 Cup flaked[/TD]
[/TR]
[TR]
[TD]Walnuts[/TD]
[TD]1 Cup Chopped[/TD]
[/TR]
[TR]
[TD]Pineapple (crushed)[/TD]
[TD]8 oz[/TD]
[/TR]
[TR]
[TD]Raisins[/TD]
[TD]1 Cup[/TD]
[/TR]
</tbody>[/TABLE]

Sorry if I've given too much detail--this is my first post to mrexcel.com.

Thanks in advance for your help. I really appreciate it.

Jared