Why don't the link cell updated with new data?

I have a workbook with multiple worksheet. Data in all supporting worksheet feed information through link cell to "Summary" worksheet. However, the new data did not reflect in the Summary worksheet. The refresh and calc button didn't work. I even closed the file and re-opened, updated, and the new data were not flow through. I have to retyped the same formula or re-link in order to have new data show through. My Summary worksheet is huge and it will be nightmare to re-write the link each time. What is the problem with this?

Thanks.
Muoi