Hello

I've been searching for a couple of hours, and I can't figure this one
out.

Basically, I have pages 1-5. On page 6, I need to reference a specific
cell. It's the same in all of the first 5 pages, but I can't actually
reference the page, because they are dumped data, and all my other
references are off of "bookends" (Placeholders on each end).

The closest tip I found was this one:

Problem:

We want to copy the contents of cell A1 from Sheets1-5 into row 2 of
the current sheet.
That is, cell C2 of the current sheet is to contain the value stored in
cell A1 of Sheet1, cell D2 is to contain the value from Sheet2, and so
on.

Solution:

Use the INDIRECT and COLUMN functions as shown in the following
formula:
=INDIRECT(\"Sheet\" & COLUMN()-COLUMN($C$2)+1 & \"\'!$A$1\")


Which would actually work just fine for my purposes, but I cannot get
the formula to work! Is this because my "sheet" reference is an array
(between the placeholders)

I can provide more data if my question is unclear. Thank you in
advance for your help :)


--
TheShaolin
------------------------------------------------------------------------
TheShaolin's Profile: http://www.excelforum.com/member.php...o&userid=35120
View this thread: http://www.excelforum.com/showthread...hreadid=548743