I need a guide/ assistance to help me make a template that will do the auto sort of and distribute this into assigned worksheets.

The main worksheet which is under the name "raw data tab", upon pasting the data the sort will be according to Region (column C) and the data belongs to " Western Europe" and the rest will follow.

** WE ( Western Europe) data will automatically feed into worksheet WE,
** AME (Americas) and LATAM ( Latin America) data feed into AME-LATAM worksheet
** AP and EMA feed into AP-EMA worksheet.

i attached the sample file ...

Note: the raw data is downloaded daily ... and the template that will produce will help me analyse the data.

Hi Vixen,

Have a look at the attahce dfile its fast and nasty but hopefully it does what you want.

I have deleted the data on the output sheets go to Sheet 3 click the button and it should update the out put sheets.

Hope this helps