How to make a selection in google sheets?

Question

excel

Looking for Excel Specialist. You need to fetch data from a table. That is, list 1 contains a complete list of people + managers who processed the application. It is necessary to make a selection by managers for each sheet, while maintaining the very structure of the table, which is located in Sheet1.