Formula for Ingredient list

[Benlinus815]

Hi there,

I am currently working as a Consultant where I travel to hosts homes and create a five course meal for them. At these demonstrations, the host needs to provide some ingredients while I provide the others. There is a menu of about ten reciepes that the host can choose from.

So, I would like to create a spreadsheet, where I enter the menu choice of the host and it automatically generates (on the same sheet) a shopping list for the host and for myself.

Does anyone have an idea of the best way to go about it.

Thanks in advance.