Macro to generate list of files in a hard drive with hyperlinks

Dear Friends,

I would like to generate a list of files and its related hyperlinks as mentioned in below example:

1. Macro should popup for selection of path (a hard drive) - for which a list of files and hyperlinks to be generated.
2. Analyze number of & name of Folders
3. Create separate sheet for each folder in the root path mentioned (but not for its sub-folders).
4. Generate list of files (file name (colA) / Foldername (entire sub-folder path) (ColB) / Filesize (ColC) / Modified date (ColD)

Illustration:
i) A popup to choose a drive (ex: D drive);
ii) after selection of drive, sheets should be created in the names of folders in that specified drive
(like in D drive: Folders are: AA, BB, CC, DD, EE)
iii) Now sheets are created in the names of AA, BB, CC, DD, EE.
iv) Create list of files (in that specific folder and its sub-folders (ex: AA & its sub folders) - as mentioned above point 4.

Is it possible to create a macro to solve the above purpose? Sample file attached for your kind ref.

Please....

With regards.

Dear Friends,

I attached a sample workbook.

Please give me a solution. Thanks.

Dear Friends,

Any help? Please....

Dear Patel,

Thanks for starting in a right direction.

This should be improved with:

1) Sheets to be created in the name of root folders
2) list of files to be created for all folders including its sub-folders with hyperlinks

Any further try? please....

Dear Friends,

I hope someone will give solution for the query.