I have a large number of files on a shared directory that I need to be able to easilly obtain a list of and to insert links to. These files are regularly updated and can have new ones added and deleted.

Ideally I would like to be able to do the following things:

1) Automatically output a list of the excel files within the directory, including those within subfolders into excel.

2) If 1 is achievable would it then be possible to automatically create links to the data within these spreadsheets that I need to extract.

I do hope somebody can assist.
Paul