Hi.
I have this massive Excel file (at least 100 or more sheets) and I don't know how to group multiple sheets together.

Suppose my sheets are named A1, A2, A3... B1, B2, B3,.... Z1, Z2, Z3. Is there a way where I can make a drop-down menu or a macro and look at just the A's, B's, etc? Another problem that I have is that I have summary pages for A, B,... Z, as well as a summary for all sheets A-Z which are dependent on the cells of those sheets. If I have a drop-down menu of some sort, will it affect the summaries?

I don't want to keep taking 30 seconds to search for sheets! Any help?