I want to create a SS with 2 sheets. The first sheet is a list of all
locations (like cites) and a summary number (like total sales) and the second
sheet is the detail of those sales.

The hope is that if I click the on the first sheet city I can view filtered
detail of that cities data.

I hope this makes sense.

Can anyone get me started or is this not possible in excel. I don't even
know the correct way to ask this.

Thanks

Dave