Problem Combining "Paste Link" & "Insert Rows"

Well, I hate only coming back to such a nice place only with problems... but here's another.

I performed a "Paste Link" to a whole sheet for the purpose of making a mock duplicate sheet. This worked fine, but when someone tries to "Insert (Copied) Rows" or drag cells around, that new row isn't duplicated to the 2nd sheet.

How do I make sure that when new rows/columns are added, they are also reflected on my 2nd sheet?

Thanks ahead of time. I already feel better.

The problem is paste link is really just filling the target are with formulas that say A1:=Sheet1!A1 So when you insert a row or do a drag/drop, the reference changes to the new location (so A1 now contains =Sheet1!A2).

You could experiment with Insert/Object/Create From File. I do this alot to put Excel into Word, I've never tried it to put Excel into Excel but seems like it should work (and changes in the source should be reflected 100% in the target).