Just a general question:
Is there any way to either:

1) Paste-special - Paste Link so the cells are then filled with absolute
references ($x$#) instead of standard reference format (x#)
or
2) Apply absolute reference format to all cell-references in a selected array?

Essentially, I need to be able to paste-link in a way that the information
referenced is the same even if something should be inserted above it in the
referenced sheet. Any ideas or solutions would be greatly appreciated.
-MikeDH