I know you know what you're talking about but it's difficult for me to
visualize what you want with the sketchy description......but generally it
sounds like you could be well served with a combination of the Autofilter
feature and some VBA macros to automatically call up what you want from the
database and put it on another sheet for analysis, and each time you would
do it, the information would be the freshest from the database........this
is really more of a project than something we can give a one-line answer
to.....but if you can get more specific in your question, by all means post
back and we'll try to help...........

hth
Vaya con Dios,
Chuck, CABGxe