I think you explained everything ok.

But you may want to reconsider and keep all your data in one location. Between
sorting and autofiltering, you may find that you're able to do more things with
it.

AntnyMI wrote:

I think you're right. There might not be a way to do this in Excel.
However, in the event I didn't explain everything correctly, I included
more of the background info in the following post: "Pulling Data from
Another Worksheet"

Dave Peterson wrote:
You're not doing anything wrong--but excel doesn't work the way you want it to
work.

--

Dave Peterson