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?