I created a drop down list of the worksheet names on a summary page. I want
to be able to select a worksheet from the drop down list and have cells on
the summary page fill with the information found from worksheet selected from
the drop down list. In other words, instead of setting a cell to
"=Sheet3!B4", I want the cell to use the worksheet from the drop down list
and then a specific column and row. Any ideas how to do this?

Try something like this example:

With
Sheet1!A2 containing the dropdown list of sheet names
That cell is named "RefSheetname"
AND
The data to be used is in A1:I30 in each sheet

Try this:

From the Excel main menu:
<insert<name<define
Names in Workbook: SheetDataRange
Refers to: =INDIRECT(RefSheetname&"!A1:I30")

Next.....On sheet1

Select a sheet name from the drop down list
Then...this formula returns the value of cell C5 on the referenced sheet
F10: =INDEX(SheetDataRange,5,3)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Mr. C" wrote:

I created a drop down list of the worksheet names on a summary page. I want
to be able to select a worksheet from the drop down list and have cells on
the summary page fill with the information found from worksheet selected from
the drop down list. In other words, instead of setting a cell to
"=Sheet3!B4", I want the cell to use the worksheet from the drop down list
and then a specific column and row. Any ideas how to do this?

Yes that will work. Thank you very much Ron.

"Ron Coderre" wrote:

Try something like this example:

With
Sheet1!A2 containing the dropdown list of sheet names
That cell is named "RefSheetname"
AND
The data to be used is in A1:I30 in each sheet

Try this:

From the Excel main menu:
<insert<name<define
Names in Workbook: SheetDataRange
Refers to: =INDIRECT(RefSheetname&"!A1:I30")

Next.....On sheet1

Select a sheet name from the drop down list
Then...this formula returns the value of cell C5 on the referenced sheet
F10: =INDEX(SheetDataRange,5,3)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Mr. C" wrote:

I created a drop down list of the worksheet names on a summary page. I want
to be able to select a worksheet from the drop down list and have cells on
the summary page fill with the information found from worksheet selected from
the drop down list. In other words, instead of setting a cell to
"=Sheet3!B4", I want the cell to use the worksheet from the drop down list
and then a specific column and row. Any ideas how to do this?