Is there a way to download data from a Google Sheets sheet and display it based on who is requesting it?

Question

Google Sheets

There is a Google Spreadsheet file. It contains the lines:

1. Ivanov
   
2. Petrov
   
3. Sidorov
   

These 3 people have Google accounts. How can I upload data from this file so that each user sees only his own line? You can do this by creating a new google spreadsheet file for each user and importing data into this file using the =IMPORTRANGE() function for each user. But this option is very narrow - you can not swap lines, new users must be added to the bottom of the list, and not alphabetically.
Is there any more convenient solution?

Answer 1

1) Make a hidden sheet for each upload, and filter there with a formula with FILTER () or QUERY (). 1sheet=1user
2) Make a File - Web Publishing for each technical sheet - and distribute links to each user.