Instead, put all those files in the same folder. Go to the Data tab on the ribbon and select Get Data > From File > From Folder, pick your folder, and click Open. You'll get a window showing the name ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback