Good day. 

I am looking for a solution for a problem, where in i have hundreds of CSV files located in a folder/nested folders.

I am trying to write a VBA script, which loads the list of files in this directory to Excel's work sheet-1 as soft links to each files. when a link is clicked, i am expecting the file contents to be loaded to worksheet 2, which would be used for further reporting purposes. 

I have tried writing a VB script to extract the list of folder contents, however, i couldn't get them converted to soft links and loading the file contents. Any suggestions on how (else) could this be achieved ?

Any help in this regard is highly appreciated. Thanks in advance.