Creating alternative views of a table that include sorting and filtering pre-applied

Hi Excel Forum,

I have a table that is used to list people and various data about them.

I want to have a separate worksheet that presents a summary view of that table. The summary view should present the same data, but with a reduced set of columns, and with some filters and sorting applied to that data.

When I choose Data -> From Table/Range, it opens up Power Query Editor and looks to have that sorting/filtering functionality. But, it tells me "The worksheet data for a table needs to be on the same sheet as the table" which prevents me from displaying this on a different worksheet.

Pivot Table doesn't seem to do this either, as it doesn't seem to be able to present the data row by row.

Is there something that allows me to do this effectively?

Thanks in advance for your help!