Macro fro transferring data from multiple sheets onto one and in a certain order

[Tonyk1051]

So every 2 weeks I get a 2 workbooks, the first workbook has 3 worksheets which i need to match the data from all 3 into a new worksheet, making sure the coulmn header and data is correct. Each worksheet usually has 10000 lines and im only only copying and pasting 8 or 9 columns worth of data . (Basically all 3 worksheets have the same header name in a differnt order and the amount for each is differnt so i put the total amount in sheet 4 in a certain order of course) The second workbook only has one worksheet worth of data about 20000 lines which only has to be re oraganized. So technically 2 macros 1 for each workbook

Sample 1.xlsm ( this is workbook1 with the 3 worksheets)

Sample 2.xlsm (this is workbook 2 that only has 1worksheet)

let me know if you need more info

 

[Marc L]

​

So easy when headers names are the same between worksheets but when it's not the case like here​

you must create an header table in a 'Settings' worksheet in order to match the headers in source worksheets with the headers of result worksheet​

or hardcode them …​