i have five worksheets and i want one figure from each to produce a chart. i
have put in the following but no joy. 'March 2005'!$B$28,'March
2004'!$B$28,'March 2003'!$B$28,'March 2002'!$B$28,'March 2001'!$B$28'

Any help please