You will need VBA to do that... check here:

Create a list of Filenames in a Directory


or google something like "vba create a list of files from a directory"