Can I output data, into excel different tab with variable value?

[Shaopingfu]

If I have a worksheet like below, and I want to output data into multi tabs,with the fixed code column and the variable value column, and named the tab with the header of variable columns.  How can i setup the output?  

Code	Value1	Value2	Value3
A	111	122	3843
B	222	445	3948
F	333	234	89
E	444	54654	454
K	555	5666	87
L	666	867	1434
C	777	53	566
Total	3108	62041	10421

Tab- Value1

Code	Value1
A	111
B	222
F	333
E	444
K	555
L	666
C	777
Total	3108

Tab - Value2

Code	Value2
A	122
B	445
F	234
E	54654
K	5666
L	867
C	53
Total	62041

Tab- Value3

Code	Value3
A	3843
B	3948
F	89
E	454
K	87
L	1434
C	566
Total	10421

[Qiu]

@Shaopingfu 
We can use Batch macro and use the Tab name as control parameters.