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.