Is there a way of using the Sheet Tabs to create a drop down list on an excel
sheet. If so is there a way when the Sheet Tab name is selected from the
drop down list that the workbook will copy over information from that sheet
into the summary sheet. The dropdown list will be on the summary sheet.

Say we want to pick a cell from the sheet selected by the dropdown. The cell
is, for example, B10.

In summary sheet cell A1 put a Data Validation pull-down that options:
Sheet1
Sheet2
Sheet3

in another cell enter:
=INDIRECT(A1 & "!" & "B10")

If the user selects Sheet1, the formula returns the contents of B10 in that
sheet.
If the user selects Sheet2, the formula returns the contents of B10 in that
sheet.
If the user selects Sheet3, the formula returns the contents of B10 in that
sheet.

--
Gary''s Student
gsnu200709


"enyaw" wrote:

Is there a way of using the Sheet Tabs to create a drop down list on an excel
sheet. If so is there a way when the Sheet Tab name is selected from the
drop down list that the workbook will copy over information from that sheet
into the summary sheet. The dropdown list will be on the summary sheet.