Excel 4.0 FILES "non-macro"

In Cell A1:
Folder Name (location) & filters e.g. C:\myfolder\*.xlsm

A Named Range called MyFiles with a formula:
=FILES($A$1)

Somewhere e.g. in cell B1:
=INDEX(MyFiles,ROW())
and drag down

REF: My Online Training Hub