I'm not sure I understand your question, but some worksheet names need to be
surrounded by apostrophes when used as a reference:

='sheet 2'!a1

So maybe:
=INDIRECT("'" & D1 & "'!B5")

is what you're looking for.

dd wrote:

This is exactly what I'm trying to do, but I'm missing something somewhere.
My tab names are Nov 1 am, Nov 1 pm, Nov 2 am, Nov 2 pm, etc. Assume I'm
trying to reference cell D10 from each worksheet. What should my formula be?
It worked for me as long as my tab names were Sheet1, Sheet2, Sheet3, etc.;
but when I created a column and entered Nov 1 am, Nov 1 pm, Nov 2 am, Nov 2
pm, etc., I got the #REF error. Help, please. Thank you...

"David Billigmeier" wrote:

Create a helper column, say D1, D2, etc. that you will put all of your sheet
names in. In E1, then, use this formula and copy down:

=INDIRECT(D1&"!B5")

Does that help?
--
Regards,
Dave


"marcon" wrote:


Hi,

I am trying to reference a specific cell address (say B5) from each
sheet in my workbook, and produce a column that contains B5's value
from each sheet. Hopefully this is enough info for someone to correctly
analyse the issue i am having. Thanks.

Al


--
marcon
------------------------------------------------------------------------
marcon's Profile: http://www.excelforum.com/member.php...o&userid=36992
View this thread: http://www.excelforum.com/showthread...hreadid=567156



--

Dave Peterson