What is the best design /how to do nested tables view in excel

[MANICX100]

In summary I am trying to come up with the best way to have a table with subtables in excel and filterable (possibly with slicers, I love a good slicer). I initially was thinking a pivot table might help but since I am not performaning calculations on the data itself that was likely a dumb thought.

The below should explain what I am looking for:

Nested.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	ID	Title	Description	Status	Main Owner	Target date Y/N	Target date	CA/PA Module (Non-Conformance)	Audit Module (Findings)	Customer Module (Complaints}	Suppliers (Supplier Non-Conformance)	Assets	Incident Module (Findings)	Source
2	1	This is a Title	This is a Description	This is a Status	This is a Main Owner	Y	This is a Target date	N	Y	Y	N	N	This is a Incident Module (Findings)	This is a Source
4
5	Each item in this table is a sub section of the first item in the table above then another item would be another group etc
6	ID	Stage Name	Stage Type	Stage Owner	Target date	Details	Display the stage actions list? Y/N
7	1	This is a Stage Name	This is a Stage Type	This is a Stage Owner	This is a Target date	This is a Details	N
8
9
10
11	Each item in this table is a sub section of the first item in the table above then another item would be another group etc
12	ID	Details	Action Owner	Action Target (Target date)
13	1	This is a Details	This is a Action Owner	This is a Action Target (Target date)
Core information

Cell Formulas
Range	Formula
M2:N2,G2,B2:E2	B2	="This is a"&" " & B$1
A2	A2	=ROW(1:1)
A7	A7	=ROW(1:1)
B7:F7	B7	="This is a"&" " & B$6
A13	A13	=ROW(1:1)
B13:D13	B13	="This is a"&" " & B$12

 

[GraH]

Looks like something similar I did long time ago.

I had a first sheet to allow user interactivity (select, enter a value, your ID. This could be a slicer. Just need to prevent users to select multiple items or at least control the formula if they do.)
Formulas would fetch all the data from different source tables.
I did us pivots that refreshed "on open", because of calculations.

With 365 if would be easier to accomplish, because of spilled arrays, dynamic arrray functions, let and possibly even LAMBDA if you are on the insider program.

 

[MANICX100]

Looks like something similar I did long time ago.

I had a first sheet to allow user interactivity (select, enter a value, your ID. This could be a slicer. Just need to prevent users to select multiple items or at least control the formula if they do.)
Formulas would fetch all the data from different source tables.
I did us pivots that refreshed "on open", because of calculations.

With 365 if would be easier to accomplish, because of spilled arrays, dynamic arrray functions, let and possibly even LAMBDA if you are on the insider program.

365 - Yes
Sadly, no to the insider program
Do you possibly have an example file I could adapt?

Thank you