Is there a way to create a pivot from multiple external worksheets. I have the same format and field names in different folders on our network. I am proabably looking at reading from 5 different files. Any thoughts or guidance is greatly appreciated. Is it an option to write a query with UNION ALL?