Formula Errors! Help please!

Hello there,

I'm doing a consolidation for a company. I have a formula that seems to work for one company, but not for another. Obviously im making a mistake, ive gone through it 4 or 5 times but just can't work out what it is. if anyone could help it'd be much appreciated.

Within the attached document, in the "Consolidation Schedule" tab, Column B should be dragging in data from the "UK P & L Stats" and "UK Balance sheet" tabs of the workbook. If you look at column C you can see that i've managed to get it working for the US company: I just cant' seem to replicate the formula to the UK company.

Essentially, column B should have the same formula as column C only using two different tabs to drag the data from (UK company as opposed to US company).

Any help would be much appreciated for this as my boss is starting to put the heat on me to finish this and this is the only thing that's missing! He hates (rightfully) hard coded cells and wants everyone formula driven.

When you open the file, click on "dont update" if it asks for this!

Cheers

Thanks again

Roger.