how to combine data in many sheets into one sheet

[harisonford]

please tell me how to combine data in many sheets in one sheet in the same workbook
in one or two steps

and not by copy paste each sheet on top of the other, sometimes i have 40-100 and more sheets to combine

 

[baitmaster]

select the first sheet. Hold shift and select the last sheet. Right-click, [move or copy]
EDIT, sorry, answered wrong question...

What does your data look like? Is the layout the same on every sheet?, Is it just data, numbers, formulas...?

 

[VoG]

This may help you http://msdn.microsoft.com/en-us/library/cc793964.aspx