I've got a workbook with 80 worksheets in. The first worksheet (INDEX)
has a vertical list of all the worksheet names. I want to lookup a cell
in each of the worksheets using the vertical list and return it to a
column on the INDEX sheet. However, I don't want to use a VLOOKUP as
this would be time consuming. What I'd ideally like is a formula along
the lines of:

='A2'!C5

where A2 is one of the worksheet names, and C5 is the cell on that
worksheet that I want to return. Is there any easy way to do this?


--
amaranth
------------------------------------------------------------------------
amaranth's Profile: http://www.excelforum.com/member.php...o&userid=26031
View this thread: http://www.excelforum.com/showthread...hreadid=393812