Help adding quantities to create shopping list from recipes & help cells to add like items

Hi I am new to this forum,

I have been trying to eat healthy in doing so there are quite a few recipes I have collected I find I don't follow them unless I plan the week before by purchasing everything and planing the weeks menu in advance. I have entered some of my recipes into excel, each recipe as a different work sheet in one work book. I made one work sheet that would reference the quantities from the recipes. I have run into several problems 1.) I have to manually add every recipe to the shopping list 2 the recipe units are not always the same I would ultimately like to have the units all convert into one unit but even if i cant do this I would like it to add all Tb all cups and all tsp of one ingredient. Is there a way to get the shopping list to automatically find all recipes that have certain ingredients or at least automate this a little. I would hate to have to update the shopping equation list every time I add a recipe. It would be nice to eventually have all my recipes in here but having to refer to every recipe in the shopping list just adds room for mistakes. I can attach what I have it that will help any. 2.) My second question is there some way to convert units lets say I need 100 Tb of something because I double the recipe and am making a lot of stuff, can I some how write this to convert everything to cups. No I don't need that exact when buying stuff but at least close so that I am not missing stuff or by too much and it goes bad. Yea there are staples you can always have but I hate food going bad.

I may want to use it too, if thats ok, and i have a few ideas on how to do what you're asking

Yea that would be OK if you use it to I was trying to attach it but not sure how to do that as I really don't do forums

http://www.excelforum.com/excel-gene...html?p=3195371
Here is a link to where they were talking about a similar item but it didn't help me much

OK here is what I have so far like I said I was just starting it but than I realized there had to be an easier way to get it to look at the ingredients

when you reply there is a button below the quick reply box that says go advanced. hit that and then there will be a paperclip icon. select that then a new window will come up, click the add files button then upload and hit the insert inline button.