Problem with OFFSET function used in Named Ranges

As you said, I am posting the sample workbook. In this many ranged names may not function properly becuase it refers to some other workbook.

But, to explain the problem, I mentioned two ranged names CNTCSC, CNTSC and I have explained the problem in detail in the sample workbook.

Please give me the solution.

Thanks in advance.

acsishere.