Generate different worksheet from cell

Hi,

Sorry if I have posted at the wrong section, not sure whether should I post here or at the VBA section.
I have the below part of a table consolidated from another programme (after a few rounds of MSExcel funtions before arriving to this stage).
byZone_01.JPG

And I want to generate a separate worksheet for each of the customers according to the zone.
e.g. a 'Norh' worksheet to include below and other worksheets for other zone.

byZone_02.JPG
Please help how should it be done? (VBA needed? or can be don't by just using formula and function?)

Thanks in advance.

Hi Ljung,
Welcome to the forum
The solution can be arrived from the pivot table only.

You can first create zone wise tabs, then copy the pivot table to each tab.
After that you can filter the zone field in the pivot table, then it would show pivot data only for that particular zone.