These questions are in relation to a previous thread here: http://www.excelforum.com/excel-prog...10#post2974010

I am attempting to create an Excel macro that I can use to track progress from appointments being set by call center employees. They will all have identical excel templates that they will be entering information into via a table in columns A:I and saving onto a shared R:\ Drive. In essence, I would like to create a separate spreadsheet, call it "CombinedData.xlsx" that will take data from the table in "Test_Employee1.xls" and "Test_Employee2.xls" (note source data is from Microsoft Excel 2003, target sheet is excel 2010), and combine it into a new table in "CombinedData.xlsx." Furthermore (and more importantly), when they enter a new appointment and save their respective file, I would like to be able to run the macro on "CombinedData.xlsx" to update all the data in the table to reflect the most recent updated data in the source files.

So far, I have used Ron de Bruin's GetData macro, as well as his MergeExample worksheet, which both contain aspects of what I am trying to do, however I can't seem to combine them together. The GetData Macro allows merging the data in the currently open worksheet, while the MergeExample worksheet and macros allow the data to be appended and updated simply by pressing "ctrl + u", however the data is merged into a new workbook every time which would then need to be formatted and saved.

jeffreybrown recommended using the following code with the GetData macro: 
Please Login or Register  to view this content.
however the code seems to overwrite the source sheets in the varSheets array on top of each other in the destination workbook. In other words, I have it running for 2 sheets in the varSheets variable ("Test1", "Test2"), and it will display the data from Test1 (starting in cell A2), and then overwrite the data from Test2 on top of the other data, however starting in cell B2. Is there a way to append the data in Test2 underneath the data from Test1? Sorry for the long post, I have been working on this for days though. Any help would be greatly appreciated, thanks a million!