Cell Reference across Multiple Workbooks

[mactoolsix]

I have several workbooks using the same data which is entered in a "source" workbook. All external references work fine until I move, or insert a row in the source workbook - then I have to go to each workbook and re-enter the the source cell. I have tried using $ in the reference, but doesn't work. What am I missing?

 

[mactoolsix]

No answers? Surely there is a way to accomplish this . . . . .

 

[mactoolsix]

Found the solution - all workbooks must be open. Then the changes in the source workbook replicate to the other workbooks.