Say your choice of sheet is in B1, then

=INDIRECT(B1&"!B30")


Regards,
Stefi

€žAnita€� ezt Ã*rta:

I am using 2003 and have a summary sheet in Excel that I want to use to
display information from other sheets. I know how to create a link.

The problem is, I have 25 other sheets and in the summary I want a drop down
box (I know how to do that too) so that I can select one of the other sheet
names i.e Training Solutions, and when I select a sheet name from the drop
down box the summary sheet beneath displays the sales and cost of sales
figures from that sheet using a link.

I was going to do a nested if that says if the value in the drop down box is
'Training Solutions' then display cell B30 (sales) from the training
solutions worksheet, if the value in the drop down box is 'Hubs' then display
the cell B30 from the Hubs sheet. Problem is I have 25 sheets and I can only
nest as many as 7 (I think). Can anyone help - I'm really stuck. I know how
to do lookups but not sure that would work either.

Thanks v. much indeed

Anita