I have an Excel 2003 workbook that I wish to split in to two sections (3
sheets and 2 sheets).
The two sheets will remain as a 'reporting module' whilst the others will be
copied many times and re-used for data gather.
I need to be able to paste the data sheets back into the worbook with the
reporting module and the formulaes to remain correct.
Is there a way of doing this? As soon as I cut the data sheets out of the
original book, the formulae change to #REF and then don't work when the new
data is pasted back in.
I know that the incoming sheets need to keep their original name but is
there a simple method I can use?

Thanks