With a customized macro, multiple lists can be filtered to a different worksheet.
1. Advanced Filter Options • Excel - Spezialfilter (1) - Möglichkeiten ...
2. Copying Results to Another Worksheet • Excel - Spezialfilter (2) - Filterergebnis...
3. Search Criteria - Including Formulas • Excel - Spezialfilter (3) - Filterkriterie...
Demo File: Currently not publicly available