Is there a tidier way to create this menu?

[nicic]

Taken me a while to get my head around what I wanted, but I ahve successfully got it working. I just wondered if there was an easier/less messy way?

Basically, aware that the workbook will soon fill up with sheets, I want an easy way to list them in a menu.
Each sheet has a product type in E4, and Name in B2

So in col C I've listed all sheets (apart form first few). Then in cols D&E I've done a little prep table with the info I need to lookup.
Col G had a drop down from product type (D), and then col H successfully lists the worksheets related to that. Col I, then hyperlinks them.
I will hide everything bar G&I
Just wondered if there was anything less messy?
Also, is there a way of protecting it? as if I protect now, it will throw an error as the menu dynamically changes
many thanks

Soap Costings Spreadsheet v1c.xlsm
	A	B	C	D	E	F	G	H	I	J
1
2						Menu
3
4
5			List of sheet names	prep Data
6			Sheet Name	Type	Name		Menu	Results	Hyperlink
7			lave and rose	Lip Balm	lave and rose		soap	Sheet3	Sheet3
8			Sheet3	Soap	Sheet3			Sheet6	Sheet6
9			Sheet4	Lip Balm	Sheet4			Test	Test
10			Sheet5	Lotion Bar	Sheet5
11			Sheet6	soap	Sheet6
12			Test	Soap	Test
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
Sheet1

Cell Formulas
Range	Formula
C7:C12	C7	=SORT(DROP(ShtNames,3))
D7:D28	D7	=IFERROR(INDIRECT("'"&C7&"'!E4"),"")
E7:E28	E7	=IF(C7="","",C7)
H7:H9	H7	=SORT(UNIQUE(FILTER(Table2[[#All],[Name]],Table2[[#All],[Type]]=G7,none)))
I7:I28	I7	=IF(H7="","",HYPERLINK("#'"&H7&"'!B2",H7))
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
G7	List	=$D$7:$D$288

 

[sijpie]

Protecting it (up to a point ) is fairly easy: put what is now column G & I in one sheet (the menu sheet) and the other columns in a hidden sheet, which you also can protect

There are other ways of dealing with masses of sheets, the most important thing here is that the 'admin' understands the used system. If the sheets are to run in the hundreds, then a more automated (VBA) system could be useful