是否有更快的方法从工作簿收集数据而不是迭代Workbooks.Open（）？

I'm working on a project where the data set is stored across thousands of Excel workbooks (currently ~14000) in a folder on a Sharepoint server, each of which gets regularly modified to reflect changes to the data subset in that workbook. I know it's not a good way to store and update this data, but that's the situation as is. I'm working on a project where the data set is