Hope someone can help. I have three tabs - lets call the tab 1, tab 2 & tab 3. In the first tab i have in cells: A2 - BD A3 - CE A4 - DF B1 - tab 2 C1 - tab 3 I need cell B2 to reference a cell in tab 2. I need cell C2 to reference a cell in tab 3. This works: ='tab 2'!$H7 Instead of 'tab 2' I want to reference cell B1 as I have a significantly higher number than my example here. Is this possible as ='B1'!$H7 doesn't work. Thanks - I hope I've made this clear.