Trying to use a linked workbook without opening the source files - Microsoft Community

I'm trying to create a database that is fed by several hundred files. Each source file contains a lot of data on several tabs, but all I'm pulling out is the summary information from one ...

answers.microsoft.com