How to auto-filter rows from one sheet to another?

Originally Posted by martindwilson

once filtered you can copy paste visible cells in one go

Even so, I require an automated solution.