Merging Cells Using Excel-VBA

Hi,

Please refer the attachment .It has a Button in the sheet4.On the click of the button 3 sheets get created.



My Requirement is :

I need to merge the cells from Column F-J based on the no. of validations that a particular filetype(Column C) has.
Eg: In module1,

filetype doc has validation1-validation 5.So merge them and give the method name.
Similarly xls has validation1-Validation3.So merge them & give the method name as method1 in sheet1.


This needs to be repeated for Module1,2 & 3.


Kindly help me in figuring out how this can be done at the earliest.

Regards
Vidya