Hi

On one of my worksheets, I have a vertical list of all the worksheet
names that are in the xls file.

Next to each worksheet name in the list, I am trying to create a
formula that references the worksheet name and returns a particular
cell value within that worksheet.

I have been tinkering with the INDIRECT function but can't seem to
string it all together.

Any clues on how to do this?

Cheers

Bull