I am trying to wrap my brain around having a master list (on excel?) that connected to the recipes, that connected to the shopping list. Hrmmm.... More to think about.
Master list: Spaghetti with meat sauce
Recipe: 1lb. spaghetti, 1lb. meat, 1 jar sauce
Pantry: 6lbs. spaghetti, 6lb. meat (canned or frozen), 6 jars of sauce
Now you have, in your pantry, 6 month's worth of spaghetti and meat sauce meals.
Do that with your other master list meals and you have a fully stocked pantry and can make anything you want from it. If you make spaghetti with meat sauce twice a month, double your pantry items.