One way using INDIRECT ..

Assuming the target sheetnames are/will be listed down within A2:A20 (say)
and the target cell references (e.g: A1, B3, D5, K20, whatever)
are/will be listed across in B1, C1, D1, ...

Put in B2:
=IF(OR($A2="",B$1=""),"",INDIRECT("'"&$A2&"'!"&B$1 ))
Copy down to B20, fill across as far as required

Adapt to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jeff H" wrote:
Can I create a list on the first worksheet in a workbook to include a
particular cell content in each of of the subsequent worksheets and will
automatically include new sheets as they are added to the workbook? Sort of
like an index for the workbook. Thanks for any help.