When you insert/delete rows/columns/cells Excel adjusts the formulae which
refer to the impacted range.

For example if you have this in a cell
=A2
and insert a row above row 2 this changes to =A3...

Hope this answers your qeusiton.

"Dave" wrote:

I have taken three separate worksheet and linked them. Each contained data
on teaching assignments of different days, times and instructors. I was able
to sort and print the information without problems.
However when I needed to change information on one of them it did not always
change on the combimation sheet. It seems if I do a straight name change or
change one cell there is no problem. But if I change several cells by
cutting pasting etc. the combo sheet is not correct.
Any idea what I am doing wrong?
Thanks for any help