I am hoping some can help me...

Lets' say you have 30 sheets (tabs) in a workbook, and they are all the
formatted the same. There is also a summary sheet that calculates then totals
from each sheet.

To sum the data from all the sheets, I use =(SUM('Sheet 1:Sheet 30'!$C$9)),
and it works fine.

However, how can I enhance the formula to add the cells where there are
pull-down menus (validations).

On the summary sheet I need the totals for X, Y and Z from cell C9 based on
what is selected from the pull down menu in cell C9.

I appreciate the help, I spent lots of time on this today, and my brain hurts.

Regards,
Fred