Hi,
I have few workbook and would like to consolidated all the tabs in the workbook into 1 excel and save the consolidated file in desktop. I have created 2 example workbook as attached. The header may not appear at the same column in every tabs. And header naming showing in different workbook is not the same, e.g "Products" column in workbook 1 but showing as "Category" in workbook 2.
First of all, i am puzzled where do i write the macro (I can't write in attached sample - Book1Data nor write in Book2Data) since every month, i will receive many different files which i needs to consolidate. Secondly, how do i consolidate and merge all the data in a new workbook and save in desktop or a different folders. I am not familiar with vba and hope somebody can help. Thanks