Hi,
So i'm working on this exercise where I have different worksheets that are dates with statistics. For the sake of simplicity, this is a brief workbook and the data is stuff I made up (the principles behind how to make this function work is what I'm after here).
On my summary page, I want to be able to pull up a certain day of a certain statistic. I know this can be done with a vlookup, but I want to be able to use a drop down menu that gives me the option of selecting the date (worksheet) and the summary of information pops up. The problem however is that I'm not sure how to source the data (in the data validation section) and I've been having a lot of trouble doing it. As of right now, I can set up cell where I can type in the worksheet name and that particular day's data pops up.
How can I have a drop down menu that lists all the worksheets, but also updates itself whenever new sheets are added?
Your help is appreciated.
Bookmarks