I organize catered camping trips. I have a number of meals containing various dishes with various ingredients. The Ingredients are quantified on a portion basis. The dish ingredients are taken from my shelves and delivered to someone who packages them for a camping trip and goes along to prepare the meals. There are multiple camping trips in progress at any given time. Grocery shopping is done for multiple trips at one time. 1. I need to be able to prepare a grocery list to enable ingredient purchase which will be based on the number of camping trips departing in the coming period, the meals to be served and the number of participants. 2. I need a 'pick list' to identify the ingredients for the individual camping trips to enable me to take the ingredients from my shelves. 3. I need to be able to enter the dishes along with their ingredients and quantities. 4. I need to be able to allocate the Dishes to Meals. 5. I need to be able to identify how many portions of these meals are required on a trip by trip basis. The trips can be identified by number. The sample Excel sheet is for one camping trip. It provides the groceries required for one trip with 6 participants. Changing the quantity of meals on the top row changes the groceries required. I currently make a sheet like this for each trip and then sum the total groceries required by item. I need to be able to specify number of participants per tri,p rather than just assuming there is 6, as our wastage is currently too high.