Merged mulitple sheets of existing workbook into one sheet

[paradise]

Dear Sir,

I want to merge different worksheet of an existing workbook(http://www.excelforum.com/excel-prog...one-sheet.html) into one by macro .I did not want to repeat the rows label for each worksheet data.Also I want to get at right hand side i.e in G column the data to be extracted for respective worksheet in the merged data.I have enclosed in attachment (http://www.excelforum.com/excel-prog...-sheet.html)an expected solution in a sheet name "merged".However the number of worksheet is here only 3 for sample purposes.However,in reality there is more than 3 .

In addition to it,I did not like to get total row which is present in respective worksheets.This will be cleared in the "merged sheet" which I have presented. I have asked this question to another www.excelforum.com at below link >>>

http://www.excelforum.com/excel-prog...one-sheet.html

I have enclosed a workbook in the above link.If any info if required,kindly do let me know.

Hope anyone could help in this regard for macro formulation.

With Best Rgds

[paradise]

I have enclosed workbook here.Kindly find in attachment.

Hoping a prompt reply in this regard.