Check text in cells and delete/add column accordingly

Hi,

Would appreciate any help :D

I receive thousands of raw data every week as shown in the excel sheet {raw data}

I would like to use a macro that could automatically sort the raw data like the format in the excel sheet {template}

For example:

Looking at the raw data and compare with the template, i would have to delete the whole columns that have (BU_CODE , EAN_CODE, SUPPLIER_CODE, SUPPLIER_NAME , BRAND_NAME, and SUB_CATEGORY_CODE) and add in columns and name it as Principal, Cateogry , Brand and range).

The sequence has to similar to the excel sheet {template}

Thanks in advanced!