|Feel free to throw in a "Please" and a "Thank You" when posting in a help forum such as this. We are all just volunteers here giving of our free time.|
You cannot "push" the filtered data to a different sheet via the Filter dialog box, but you can "pull" it.
1 - Name the range that you want to filter, e.g. myRange.
2 - On the sheet where you want the filter data to reside, open the Filter dialog box and use =myRange in the "List range" field.