How to get cells from another Google sheets and filter them without changing the main sheet?

Question

Google Sheets

I have one big project table with project parameters and customers. I want to make some sheets to import to the site and I need to pull data from the main page. But if I use a filter on other pages, then the order on the main page also changes. How can I use the data from the first page without changing its order?

Answer 1

Probably, on each sheet you need to "pull" the data using the FILTER formula. Then the need for a filter function will disappear.