View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Patti Patti is offline
external usenet poster
 
Posts: 45
Default pull data from multiple sheets based on input

I have several worksheets that all have the same format, I would like to have
an additional worksheet that has a drop down cell listing all worksheets and
then have the data pulled from the worksheet named in the drop down cell. Is
this possible?