Excel Speedometer Gauge - urgent help

Hello,
I have created some excel speedometers that my company has requested for their KPI's but for some reason I'm struggling to get the speedometer needle to match my data targets. Please anyone who can help me on this will be very much appreciated. I've enclosed my speedometer excel sheet for your reference. The main sheet has the main speedometer which works absolutely fine, click on the drill button to go into detailed speedos and this is where my problem is and im struggling to get my head around this. Please help!!!

Thanks in advance.

Regards

Afroz