I have a file that contains many workseet tabs.

The tables are numbered, like, 100, 200, 300, 400, 500, etc and represent
names of departments

An individual from a given department will open the workbook, and select
their respective tab.

If thier department number is at the end of the range, it is difficult for
them to scroll across the bottom of the workbook to find thier sheet tab.

Is there a better way to organize or find worksheet tabs?

Can worksheet tabs be listed down the left margin instead of across the
bottom?

Is there a way to create a "table of contents" or something similar that
will access the individual tabs?

I did see Views, create custom view, and this looks like it work work,
however since another program creates the excel workbook and all the tabs
each month, I would have to do a l;ot of manula editing to create a custom
view. Is there a better way?