Consolidation error!!

[Guest]

I have a workbook with the following worksheets (ALL of which are set out
exactly the same) YTD, JAN, FEB, MAR etc upto DEC.

When I try and consolidate the JANEC data on the sheet YTD, I keep getting
an error: Cannot open consolidation source file 'DEC'.

I have thoroughly checked to see if worksheet DEC is in any way diferent
form the other sheets and it is not. I have used the Data-Consolidate option
for the consolidation.

Can anyone please suggest what is going wrong and how to fix.

Regards

 

[Guest]

ALso, If i try and do a consolidation leaving out DEC then the same error
message applies but this time it cannot open source NOV, and so on as I go
down the months. It seems that the consolidation will not recognise the LAST
month selected!!