Linking cells to follow the data when changed

[Sykamo]

Hi!
So I know how to link a cell to a different tab; however, the cell I want the information from is part of a table. And when I sort the table differently from when I first linked it (ex: sorted by A to Z but changed to Z to A) the cell now changes to whatever new information is now in that specific cell instead of following the data I needed. How do I link it so it follows the info and not the exact cell?

Ex: I link cell A3 from Tab 1 to A10 in Tab 2. A10 is part of a table that I’m now sorting by year instead of month so the info in A10 moved to B10. My linked cell in A3 still shows content displaying in A10 but I want it to follow to B10.

Hopefully that makes sense. TIA!

 

[Fluff]

Duplicate to: Linking cells

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.