Does anyone have any ideas on how best to copy a relatively large
range while maintaining the original cell references.

The range to be copied is relative within each block, i.e. formulae
can be copied from one cell to recreate the whole table - for this
reason i wanted to avoid introducing dollar signs everywhere, although
that in itself would be fairly time consuming. I'm also trying to
avoid repeating data unnecessarily.

Hopefully someone may have come across a similar problem.