How to transfer data from one sheet to another?

Question

Google

Task: transfer information from cells to another sheet using a hard link to information in cells.
I did it with ='Original'!$B$11 and ='Original'!B11
Problem: when sorting data in the original table, the information on the "copy" sheet flies.
Link to the spreadsheet: https://docs.google.com/spreadsheets/d/1yctHkre_t-...
Is there any solution?

Answer 1

Good afternoon!
If I understand the task correctly, the IMPORTRANGE function will suit you.
In your document, I created a separate sheet with the same name and implemented the function.