I recommend you look at Data / Filter / AutoFilter
You can make extracts using AutoFilter followed by copy and paste
or by Data / Filter / Advanced Filter / Copy to another location
But don't try to keep the different lists in sync.
Just redo the filter when you need it.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup