How do I reference the same cell, but in different worksheets?

[marcon]

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

[David Billigmeier]

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
>
>

[Glenn Rathke \(Soft Design Consulting\)]

Why not cycle thru the Worksheet collection? Then if sheets are added or
deleted, the code always works.

Glenn



"David Billigmeier" <dtbill21@hotmail.com> wrote in message
news:B08C2F9A-2E89-45DA-B88B-B7FF9F565E0E@microsoft.com...
> 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
>>
>>

[marcon]

i guess i am also trying to link the names of each of the worksheets to a column in my master summary sheet. Basically, i am trying to make a template that updates the names of each of the sheets based on whatever the value is in the master sheets column.