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