How can I do that?
Can you please share a sample file?
It depends on formulas you use, but, if without VBA, INDIRECT() will be as the basis. If, for example, you'd like to pick-up the value in cell C2 from another tab, it could be
or, the same but with more flexibility