Hi Peter Oz 67,

On your summary sheet:
1. Put your source sheetnames in cell A2 and in the cells below it
e.g. Sheet1
2. Put your source cell references in cell B1 and in the cells to its
right e.g. B32
3. In cell B2 enter:
=INDIRECT($A2&"!"&B$1)
4. Copy this formula to the other blank cells in the table

Cheers,


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=531276