Link based on worksheet name?

[Guest]

I have a workbook that contains a summary worksheet as well as the detail
sheets broken down by topic. The detail sheets all contain a value that has
consistent placement that I would like to reference in my summary sheet.

For example, summary sheet contains: Toys, Books, Clothing in cells A2, A3
and A4 respectively. I want to include the value from cell B4 in the detail
sheets which are named Toys, Books, and Clothing.

The summary sheet is fairly extensive so I do not want to have to select
each sheet indenpendently. Is there anything that I can (e.g. a forumula or a
feature) to make this process a little easier?

Thanks!!

 

[Duke Carey]

Try

=INDIRECT($A2&"!B4")

If you want, you can put the "B4" (and all your other detail sheet target
cell addresses) into appropriate cells on your summary sheet & then use
something like

=INDIRECT($A2&"!"&B$1) where B1 on the summary sheet contains the text "B4"

This allows you to copy the INDIRECT formula to other cells and have it
adjust to whatever target cell address you have entered in the first row of
the summary sheet