I need a way to have a worksheet from two separate workbooks to connect to a third workbook I am using. One would say to use Power Query (Get & Transform Data) but it is way too slow. Especially if those files are .xlsb. Another option would be to use a cell reference to the file. But that would then require opening the files to update the data which would be counter-intuitive. Any other ideas? Go!
