There was a problem with the command: Sheet → Link to external data. Does not work properly. I believe the link should return the value of cells from the selected source. If the source contains a formula, the result of that formula, not the formula. In fact, the process brings the formula to the target area. In my opinion, this is contrary to the idea of receiving external data.
+1
The effect of copying filtered records is analogous to that described above. In my opinion, it is also a bad solution.