Filtered Menu for multiple worksheets? is it possible?

[nicic]

So I have a workbook which a has multiple worksheets for different cosmetic products eg soap, lip balm, lotion. Each one is labeled on the page, in the same cell.
I have a menu sorted with hyperlinks, but obviously It's going to get silly long as more products are added.
In my ideal word, I'd like a drop down list of all the variations (I can do this), then when say 'soap' is chosen, it lists all the worksheets related to soap, hyperlinked and sorted a-z. NOt asking for much am i lol
Not sure if it's possible, but would make life a lot easier

Any guidance appreciated, before I go down a rabbit hole.

Thanks