Using a drop down to pull data from another sheet

Hi everyone. I'm trying to do the following. I have a drop down that provides all of the sheet name in the workbook. When the user selects a sheet name, I would like specific cells to pull data from the sheet name selected. What I thought would work is =Sheetname(A1)!E3 where the cell would pull data from cell E3 from the drop down sheetname in A1

you can use a drop down down to pull information from another sheet using vlookup.. but i dont think you can pull from multiple sheets .. just because you can't nest multiple sheets in datavalidation (drop down) you can have multiple drop downs that have headers with the sheet name on them.. like A1 is looking at sheet 10 and B1 is looking at sheet 11 C1 is looking at sheet 12 etc..

Hi
There are many different ways to achieve the same thing in Excel. The trick is first to fully understand what you want to achieve. Can you post a sample of what you have and what you want the finished article to look like, leaving out anything sensitive. That will help us investigate the way forward (if there is one).
Tony

Drop down for sheet name.xlsx

Thank you Tony The attached file provides a sample of what I'm trying to do.

Kevin,

Thank you and that worked perfect. My mistake however, The drop down will be missing the "store" string. Is there a way I can add the string "store" to your indirect statement? I have the sample attached.Drop down for sheet name V2.xlsx

Never mind on that last post. Thank you Kevin!