I am working on a group of excel sheets and i need help with a formula.
What I am looking to do is have a formula that when i enter the data in one cell it transmits the change to other cells. Now this in and of it self is fairly simple, here is the part im having trouble with.
I want the values to stay correct across the multiple sheets no matter how they are sorted. So if i sort sheet A for one specific value, be it name or whatever the sheets that pull data from that sheet will keep the correct values from the cells they are pulling from, even if it changes from cell A2 to cell A54 or whatever. can this be done?

Thank you all in advance