如何在不打开VBA的情况下从Excel工作簿中检索数据？

I have a folder, which is selectable by a user, which will contain 128 files. In my code, I open each document and copy the relevant data to my main workbook. All this is controlled through a userform. My problem is the time it takes to complete this process (about 50 seconds) - surely I can do it without opening the document at all?I have a folder, which is selectable by a user,