What I know about Excel is very dangerous. I am self taught and am able to JUST get my work done. It took me almost 6 months before I could finally say that I knew what I was doing. There is still a huge part of this programme that scares me and I am very careful about which buttons I press. I am almost always double and triple checking myself.

To my problem.
I have a workbook called - New Ledger 2007.
In here I have separate worksheets for the usual payments and receipts. For eg. one worksheet is for the telephone account, another for my petty cash, another for the rental of the office equipment, etc, etc.

In this workbook I also have my Financial Statement which I have called - Fin Stat.

My other workbook is called - Other Accounts Ledger 2007.
This one is for the accounts held by different groups. For eg. I have a worksheet for the CareFund, another for the Women'sAuxiliary, another for RepairsMaint, etc, etc.

After a long hair-pulling session I have finally figured out how to link the worksheets in the New Ledger 2007 to the Fin Stat (all in the same workbook).

My problem now is - How do I link the total figure in CareFund in the Other Accounts Ledger 2007 workbook to the Fin Stat in New Ledger 2007 workbook?

In the CareFund the total is in cell N4 and I need to link it to cell C24 in the Fin Stat.

I would be soooooo grateful for all your help.