Consolidating data from two separate workbooks into a third

[Ezzard]

I have two users who each have a workbook with their own collection of data. What I would like to be able to do is consolidate the data from these two workbooks into a third workbook. All of the data is formatted in the same way (same headers, same # of columns, etc.) so there won't be any missing information. I know there is a consolidate option built-in to Excel, but from what I can tell that will only work within a single workbook. Is there any type of VBA that will allow me to do this relatively simply?

[Faridwahidi]

Hi Ezzard,

For sure VBA can do, pls post your workbook

[Ezzard]

Okay, here are the sheets.

Sheets 1 and 2 are the separate workbooks that the users have and the Master Sheet file is the sheet that I want to be able to pull all of the data in to. I have included a before and after sheet in the Master Sheet file in case that helps.

[xlbiznes]

try this solution.