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.
Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.