I was using Data > From Folder and building a query from a folder with 115 workbooks in it. I kept getting errors. I discovered some of the workbooks had an additional worksheet, and removing that from the workbooks solved the problem. But I found that tab by manually opening each workbook and looking to see if it had that additional worksheet. Is there any way to use PQ or some other tool to tell me which workbooks are causing the problem? (Would have saved me having to go through each workbook.) 

Thanks
Catherine