bring files names and images based on headers and hyperlink from folders and subfolders

[Hasson]

hello

I know this question is very complicated so I have many files are different in files extensions each one of them contains folder its names are matched with the headers in the main directory is "E:\SUMMARY" the folder summary contains many folder based on current year 2020,2021.... and so on the folder " current year " contains many folders it's names based on the headers are PDF,AVI, DOCX as in my picture and the pictures are in this directory "E:\images" and contains many folders contain the images the folders which contain images its names the same headers .

so what I want create sheets based on current year should be like this " summary files 2021 " and if folders ' names which contain files are matched with headers' names which contain files extension then brings the files under the headers which contain files extension and if the folders ' names which contain images are matched with headers' names which contain ICONS then brings the images under the headers which contain ICONS and fit in the cell and hyperlink the images then when press the image open the file
the headers starts from COL A: V and increasable

thanks in advance

 

[Hasson]

I know this thread is very complicated but I hope from the experts see my thread

 

[Marc L]

Hi,​

​

according to how Excel badly manages the memory it's a no sense to duplicate an icon within the same column,​

should be better to put a single icon in the header.​

​

And obviously a crystal clear and complete elaboration of the need is necessary …​