Referencing worksheet names from a list??

[Ace70]

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

 

[T. Valko]

Try this:

A1 = Sheet Name

=INDIRECT("'"&A1&"'!B27")

Which evaluates to:

='Sheet Name'!B27

 

[Ace70]

Awesome! Perfect. Thanks

 

[T. Valko]

You're welcome!