General Dynamic Excel Question

Now I am not sure if this is even possible in excel but I thought I would ask if it was and how I would go about doing it.

My current problem is that i have an excel document with too many sheets, I am talking 100+ and it is difficult to navigate even with color coded tabs and naming conventions. The workbook is being used to Schedule and track progress on various workout programs.

I have seen that it is possible to make a dynamic chart that is controlled by a drop down menu, so I can have a Program A chart with Workouts A,B,C and have the dropdown list switch the chart contents based on the workout. I can figure out how to do this.

My real question here is that I have tracking sheets for each workout for each program, so Program A has 5 workout tracking sheets which gather weights and reps, Program B has 10, tracking sheets etc. Currently each tracking sheet is on its own independent sheet.

Is there anyway to use a dropdown list to control the visibilty of a range of cells. So I can designated a Range A6:C30 for Workout A tracking sheet and when Workout A is selected from the drop down list these cells are the only ones visible (besides the header rows) and the user can dynamically change between them as needed.

Any input would be appreciated.

I don't have an idea using a drop down list for you, but want to offer another suggestion for your consideration.
If you gather your information in a single sheet, rather than 100+, there will be several ways to get the info you want quickly. I know how painful it would be to get all info on all sheets using the same columns on each, then copying them all to a MASTER listing, but after that is done, you can get so much more data very quickly. Likely you'll spend less time moving around your sheets and more time get data entered and stats pulled as needed.

Hope this gives you another process to consider.

I do have a master sheet that all of the charts are based off of, the difficulty is when the user is selecting the correct sheet to enter in their workout information they have so many options.

The spreadsheet, is designed to take a number of preexisting programs that the User is familiar with each one having 5-15 individual workouts and creating a custom hybrid workout that incorporates workouts from these various programs. So they could if they choose be using every sheet at one time or another.

This workbook is not only for my use but for clients to use as a form of accountability and progress tracking

I believe that it may be possible to use a drop down list to hide the unnecessary rows and only show the tracking sheet that they need.

I will test this out but if anyone else has any other suggestions that would be great

I will see if I can through something together