Copy data from different worksheets to one consolidated file

[amielb]

Hi!
I am fairly new to Excel macros/VBA. I need all the help I can get from you guys.
I have a sheet (I'm gonna name it Consolidated File) where I would like to dump data from two different excel files - let's name them File A and File B.
The two different files are identical in nature - they both have the same number of columns (Columns A to K) but would have different total of rows on a daily basis.
I would like to have the data from File A and File B to be dumped to Consolidated File without overwriting the existing data in it - meaning, when File A saves the data to it, if there's an existing data, it will paste the data to the empty row after the last record. The action will be triggered when a button within File A or File B will be pressed.

I have attached the files for your reference.

[amielb]

By the way, just in case this query will be solved, please help me mark the thread "solved". I had a challenge in doing so with a previous post.

[amielb]

Anyone? Help please....

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[amielb]

Thanks John.
This gave me another approach to a similar case.
I have a question though...
Let's say I have File A opened. Then a colleague of mine has file B opened. I will be the one copying the data first by clicking on the "consolidate" image in the file to have the data in my sheet copied to the consolidated file. Same process will apply for my colleague. He has File B opened then he will be copying the data to the consolidated file by pressing the "consolidate" image as well. The data copying will happen even without having to open the consolidated file.
Here's how the process would go. Files A and B are being worked on by two different users from different machines, while the consolidated file is in a shared drive in our network.

I hope this gave you a better picture of the scenario. Thank you so much!