Getting #REF1 because re-pasted a replacement worksheet
 

Hi
I've created a workbook and have imported 3 account data sets into 3
different worksheets. I then have a fourth worksheet that picks data out of
the other 3 and presnets consolidated figures (essentially merging three
accouints into one management report). I've done Jan-April for all 3
originals and have everything perfect on he fourth "consolidated accounts"
worksheet.

I have to (obviously) re-import the 3 account data sheets each month.
Whilst the layout remains identical, the Consolidated sheet objects with the
#Ref! even on the Jan-April colums whihc haven't changed. It just doesn't
seem to like the fact that I've re-pasted the same data over the first
Jan-April columns.

Anyone know how I can get it to accept/ignore the fact I've repasted?