"KePaHa" wrote:

On Sheet 2, cell B12, type =Sheet1!G23 to display the contents of that cell

"Peter J Watson" wrote:

I want to input a cell reference into a cell and then display the contents of
the same cell references from other sheets within the same workbook. How do
I do this?

Not quite what I am looking to do. I have information on 7 sheets (2 to 8),
each one represents a courier servive - on each sheet the columns (A, B, C
etc) represent area codes and the rows (1,2,3 etc) represent weights. I want
to type into cell A1 <AC100 on sheet 1, where the area code is AC and the
weight to be used eg 100. I would like to display in C1:C6 the values from
sheet2!AC100, sheet3!AC100 etc

Any ideas?