Sorry if this has been solved, I can't find in the search anything on this. I need to be able to pull information from all workbooks in a folder. Each workbook has a worksheet with the same name and format that the information needs to come from. The workbooks are randomly named so there isn't a way to specify specific workbook names. Also, the workbooks can't be open to retrieve that data. Any ideas or links would be greatly appreciated.