Hi There

I would like to create a table which reports values from various sheets, depending on which options I select for the table in the form.
In the attached example I have sales data on three sheets: Cheese, Milk and Yoghurt. The format of each sheet is exactly the same, only the Brand Names are different (although I have the same number of brands on each sheet).
I want to create a summary table on Sheet 1, where I can select a parameter in each of the yellow highlighted cells (I would like this to be form controls), and it should return a table for me.

The three parameters I need to select are:
1. Cheese/Milk/Yoghurt
2. Low Fat/Full Cream
3. East/West

For example, in the table, I want to return the sales values for Cheese, Low Fat from the East. The table should list all brands (Brand V to Brand Z) along with the sales values.

Hope I’m explaining myself clearly!