Allow Textbox to use a dynamic cell reference that auto-includes worksheet name.
Assigning a cell link to a text box is easy, Highlight the text box then in the formula bar, simply enter =A1 or whatever cell you like.
But when cutting and pasting the text box to a different worksheet, the original cell link reference remains in place. Instead of changing the reference to something like: ='origsheet'!A1 the =A1 value remains as the linked cell. In other words the text box will get its value from the sheet where the text box was pasted, rather than from the source sheet.
As a fix, I use a named range.