bring sub directory from main directory and open when press cell

[leap out]

hello

I have this main directory "C:\Users\pc-aa\Desktop\dr" and contains folders and each of folder contain sub folders . so what i want bring all the sub directories from the main directory in multiple columns and open when press any cell and every time I create a new sub folders in folder is existed in same column then add in the same column and if I add a new folder in the main directory then should create a new column for a new folder it shows a new sub directory in a new column .

note : the headers are the same folders' names which are existed in the main directory and under the headers are sub-directory for each sub-folder



this is expected my result

da.xlsm
	A	B	C	D	E	F
1	DIRECTORY1	DIRECTORY2	DIRECTORY3	DIRECTORY4	DIRECTORY5	DIRECTORY6
2	C:\Users\alhagag\Desktop\FL\DIRECTORY1\AA1	C:\Users\alhagag\Desktop\FL\DIRECTORY2\BB1	C:\Users\alhagag\Desktop\FL\DIRECTORY3\CC1
3	C:\Users\alhagag\Desktop\FL\DIRECTORY1\AA2	C:\Users\alhagag\Desktop\FL\DIRECTORY2\BB2	C:\Users\alhagag\Desktop\FL\DIRECTORY3\CC2
4	C:\Users\alhagag\Desktop\FL\DIRECTORY1\AA3	C:\Users\alhagag\Desktop\FL\DIRECTORY2\BB3	C:\Users\alhagag\Desktop\FL\DIRECTORY3\CC3
5	C:\Users\alhagag\Desktop\FL\DIRECTORY1\AA4	C:\Users\alhagag\Desktop\FL\DIRECTORY2\BB4	C:\Users\alhagag\Desktop\FL\DIRECTORY3\CC4
6	C:\Users\alhagag\Desktop\FL\DIRECTORY1\AA5	C:\Users\alhagag\Desktop\FL\DIRECTORY2\BB5	C:\Users\alhagag\Desktop\FL\DIRECTORY3\CC5
DIC

 

[leap out]

I made mistake about directory
this is the right C:\Users\alhagag\Desktop\fl"

 

[leap out]

any helps guys?