Reading multiple sheets with different headers and merging data - Help required

[hiteshnpwc]

I have a dataset with multiple sheets and want to merge all the sheets based on the headers, also If new column is added it has to be added in the respective column

Attached is the excel sheet. 

[Qiu]

@hiteshnpwc 
There is a very good macro "Multi Sheet Import Example".

Try to configure as per your real data.