I want to extract information displayed after filter to another spreadsheet.
Can anyone help me to write a macro for that please?

A simple copy and paste can be used but I have to abstract data out og
number of spreadshhet for number of report and its getting tedious.

Thanks.