How arrange files names based on modified date within folders and subfolders

[Alaa mg]

Hello
I have files within folders and subfolders in this "C:\Users\Alaa\Desktop\FL"
the files will be PDF, for all of extensions for EXCEL
example :"C:\Users\Alaa\Desktop\FL\inv1.xlsx

"C:\Users\Alaa\Desktop\FL\rett\ACC.XLSM"
"C:\Users\Alaa\Desktop\FL\rett\files\proc.pdf"
so I want populate ITEMS in column A (1,2,...) , EXCEL files in column B, column C show modified dates for EXCEL files inside EXCEL FILES sheet , I want populate ITEMS in column A (1,2,...) , PDF files in column B, column C show modified dates for PDF files inside PDF FILES sheet.also hyperlink columns B for both two sheets to open file when click the cell in column B and sort From descending to ascending based on Modified date .
every time run the macro should replace files names for both two sheets.
in both two sheets will contain headers in row1(ITEM,FILES NAMES,MODIFIED DATE).
thanks

 

[Kaper]

It can be done with VBA but why not use Power Query for that purpose? See a good tutorial by Mark Proctor here:

 

[Alaa mg]

thanks.
I don't prefer PQ and I don't used to use it , I no know how use .

 

[alansidman]

Here is an alternative to PQ

 

[Alaa mg]

not like what I look for it !