Help with referencing filtering data results only

Frequent Visitor

Hi everyone

I have a filter table set up with various data across 10 or so columns. Once I have set the filters for the various columns (isolating the info I need), I would to automatically have those rows copied across to another sheet. 

I do not want to manually copy. This must happen seamlessly for other reports I need to set up and send off.

Can anyone help?


Thanks in advance