Dave (dlmille) helped me with this so maybe it would be quickest if he responded.
The solution you provided worked with a piece of what I am attempting to do. In reality I have seven tabs of data I need to move into the spreadsheet. When I originally created the macro it was too large to handle all seven tabs so I broke it into three macros and called 2 from 1, 3 from 2 etc. This worked great when working one line at a time. After I got your solution for opening multiple workbooks I applied the logic to the three macros I developed executing each one with a different control key (ctl/r, ctl/s, ctl/t). Ideally I would like to be able to execute using ctl/r and loop through all of the tabs but I thought it would take me too long to build and took the easy way out.
The problem: The Macro 1 works fine. Macro 2 and 3 are not incrementing the destination row (X = rDest.Row) consistently. I have done extensive testing and cannot find a pattern. I am attaching the code and workbook folder.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
-Mike Kapnisakis, Warner Bros
With your subscription - you'll gain access to our exclusive IT community of thousands of IT pros. You'll also be able to connect with highly specified Experts to get personalized solutions to your troubleshooting & research questions. It’s like crowd-sourced consulting.
We can't always guarantee that the perfect solution to your specific problem will be waiting for you. If you ask your own question - our Certified Experts will team up with you to help you get the answers you need.
Our certified Experts are CTOs, CISOs, and Technical Architects who answer questions, write articles, and produce videos on Experts Exchange. 99% of them have full time tech jobs - they volunteer their time to help other people in the technology industry learn and succeed.
We can't guarantee quick solutions - Experts Exchange isn't a help desk. We're a community of IT professionals committed to sharing knowledge. Our experts volunteer their time to help other people in the technology industry learn and succeed.