Having some difficulty with linking cells between worksheets

[CHEECHBURGER]

I have 5 worksheets each with several tabs. I use “=” then with the mouse point to the cell I wish lined. The data goes in and I save it. On the next day, I make changes to the linked sheets and they do not update other sheets linked to the cells. I have added all the sheets in the Security screen as trusted locations Recalculate automatically is set and protections are off and calculate automatically for trusted sites is on.

but when i SAVE THE spreadsheet and open it again on the next day the data does not automatically update to changes I have made. and i get REF or some other error - no code.

any ideas?

[anon73440385]

Duplicate of Having some difficulty with linking cells between worksheets

Please delete this one and keep track on the existing question.