I'm afraid that doesn't work too well either.

I do need something quite hands off. This is a model for a client.
Seperate worksheets have been setup that autofilter out irrelvant
entries based off a base datapile of 5400 entries. Each sheet displays
certain values, and I want to be able to summarize at the bottom of the
page FROM the automatically filtered list. Every few weeks a new base
data pile will be put in and everything will change, so the approach
needs to be formulaic. Im thinking it may not be possible, but here's
hoping :crosses fingers: