Copy data from many sheets into a new sheet in different design setup

Hi there, I would like to create a macro that copies data from Sheets("Q7.1").Index To wsCount into a new sheet.

I am not sure how to accomplish this, but I think the best way to explain this is with pictures.
Template for RC Analysis of questionnaire ver2.1.xls
http://imgur.com/5UtWP9x&AsJSucT

So if you can see the first image is the data I would like to copy, one sheet is one question.. I want to add all questions into one sheet as the second image..

So from each sheet I would like to copy
sheetname = column A
frequency of 1 = column B
frequency of 2 = column C
frequency of 3 = column D
frequency of 4 = column E
frequency of 5 = column F
Total = Column H
Average = Column I

and if possible
Standard Deviation = Column L

Template: Template for RC Analysis of questionnaire ver2.1.xls

Is this possible?
Sorry for the language.. English isnt my native language


Regards,
Christopher