Linking cells, not data

I'm sorry if I do a poor job of explaining this or if this has been covered before. I tried running a search but came up dry.

I am trying to link cells between two worksheets in such a way that, if I insert a row in the source worksheet, the cells on the linked worksheet do not get messed up. In other words, say I have data in the source worksheet in rows 1-10 and want to link cells A1:A20 in a new worksheet to cells A1:A20 in the source worksheet (the extra rows are to accommodate new data to be entered in the future in the source worksheet). If I attempt to do this by simply copying the range from the source sheet and pasting it into the new sheet as linked cells, then when I add a new row 5 to the source sheet, the change is not reflected in the new sheet. Instead, new cell A4 is still linked to source cell A4, but new cell A5 becomes linked to source cell A6 after the row is added, as though it was "following" the data that had been entered in original source cell A5 after it got shifted down to row 6 following the insertion. I don't want this, if I can avoid it. Rather, I would like the links in the new sheet to act like "windows" onto whatever is contained in the source cells they link to, regardless of how those cell contents change when new rows are added.

Any suggestions? Thanks in advance.

Can you not just paet the new data over the top rather than insert extra rows?

Originally Posted by MarkFranklin

Can you not just paet the new data over the top rather than insert extra rows?

No. I don't need to or want to change or delete any of the source data cells very often (or ever, really)...just add new rows with new source data (or potential source data, until I can get this issue fixed).