Recommendation on different worksheets

[radicalrom]

I am using the index function on a lot of data. To make it quicker I have split off my data into multiple worksheets. I have a drop down list and the user would select a state. Each worksheet is a state.



I have no problem of when a user selects a state that it somehow copies that data from the correct worksheet and then the index function could run on the current sheet. Maybe you can somehow index directly the correct worksheet after it is selected.

There maybe another way to solve this issue. If you have an idea, I am willing to run tests.

I am attaching a basic example file and B1 cell is the pull down. Once the user selects a state, I would like it to get the information from the correct worksheet (to make it easy the values in the drop down = the worksheets name).


Thank you so much for your recommendation.

Jeff Unruh