I am working on a spreadsheet where I have a list of companies and their customer transaction #. As an example Company "ABC-1" represents the customer and transaction number. My company has a folder listing the transactions based on company, so the folder will be named "ABC" and inside the folder will be "ABC-1", "ABC-2", etc...

On my spreadsheet I need to look up the "status" of the orders for each transaction # so normally I look at the ABC-1, go into the folder, open the respective file, and copy the status over to the spreadsheet. I have over 2000 of these and I need them to be completed relatively quickly, is there a way to do this with VBA?

Thank you for any and all help!