linking cells between files when cell address changes

[joneckenrod]

I need to know how to keep information in cells from one file linked to another file when the address for that cell changes. In other words, if J34 in file A has information linked to F29 in File B, and because I had to insert a new row of information in File A, J34 now becomes J35, I would like F29 in File B to stay linked to the File A cell that is now J35. In our costing system (which I am new to--I'm also new to Excel), we have multiple files with linked information, but right now any time new information is added (because a new piece of inventory has been added), it throws off the whole system, and it is almost impossible to track every place where the information may have changed. Making information flow even when cell addresses change is crucial--if it can be done. Any advice will be greatly appreciated. Thanks.