Hi Greg in CO,

The ADDRESS function will accept a sheet name from a cell reference
=ADDRESS(rowNo,columnNo,1,0,SheetName)

Combine this with the INDIRECT function to get the value of the cell with
that address.

There is a sample showing how to build charts using this method at
http://edferrero.com/ExcelCharts/tabid/102/Default.aspx

Look for the 'Reporting' sample.

Ed Ferrero
www.edferrero.com