Briefly! FileName Lister is a user friendly way to get a list of file names into a new Workbook.
In this add-in you have a option to list the file types you want and you can also filter on the file names. Another option is to create hyperlinks so it is easy to open the files.
Note: FileName Lister is available as freeware. But you can use the Contact button in the menu if you want to support the development of this add-in.
FileName Lister for Mac Excel 2016 (version 1.0, 4-Dec-2016)
How to install the Add-in after you unzip it on your Mac
Now look at the end of the Home tab and you see a button named Get Files to open the add-in
If you want to see VBA code examples for this see this page : Loop through Files in Folder on a Mac (Dir for Mac Excel)
Note: the location of the files are important in Excel 2016 because of Apple’s sandbox requirements, read this page and use a folder in your Office folder to avoid problems.