I have 3 excel workbooks (A, B, C) with multiple worksheets. Each one of the workbook have 2 worksheets (1, 2) with the same columns and same formatting.
This 2 worksheets are the ones that I'm interested on.
I need to have a new workbook (D) with 2 sheets (1,2) who consolidate the information of sheets 1 and 2 of workbooks A, B, C.
I need that everityme I open workbook D the new lines that I could possibly had add to files A, B and C appear in file D.
And that's it.
I know that I have to build a vba macro who copy all the info from sheet 1 of workbook A and when find a blank line stops and copy all the info from sheet 1 of workbook B and when find a blank line stops and copy all the info from sheet 1 of workbook C.
And the same for sheet 2.
But I don't realy know how to write the code...
Can anyone help me?