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.