Unfortunately, this is currently not supported.
Saving to Excel and using that Excel file is the way to go.
You cannot use worksheet as a data source to another workbook. The workaround I would suggest is below
- Save the same workbook as a new Workbook
- Add the Filters of your choice/requirement to data source Filters
Hope this helps. Let us know if you need any more information.