VBA Question

[prkhr]

Hi

I need help in VBA coding

I have region wise different excel worksheets and on each sheet in column D there are some comments and in Column E and F I have values against which there are certain headers in column H

Now I want to collect all the comments from column D and values from column E and F and populate it in a new sheet region wise and append it under different headers which are there in column H

so that all the comments are placed vertically region wise under different headers

Contract/Product/Region	On Off	On Off	Tranding	Tranding	Contra	Contra	timing	timing	Comments
	Column E	Column F	Column E	Column F	Column E	Column F	Column E	Column F
east									Column D
west									Column D
north									Column D
south									Column D

<tbody>
</tbody><colgroup><col><col span="8"><col></colgroup>