Yes.

You'll need a macro for that. Changing a sheetname causes changes to all
local and remote formulas that depends on cells in this sheet.

So before you ask "which macro", let me ask which specific cell and how does
it change its value?

Best wishes Harald

"Eric D" wrote in message
...
Is there a way to get a Tab name to reference what is in a specific cell?
--
Eric