Appending worksheets into a summary sheet

[Exceluser101]

Hi There:

I have a spreadsheet that contains multiple worksheets with different data.
I would like a way to summarize the contents of each worksheets into one 'summary sheet'. So the result would be one worksheet with data from other sheets appended.

For example, if I have worksheet A, worksheet B, worksheet C and worksheet D. I would like to be able to have a summary sheet that contains data from worksheet A, then appended below would be data from worksheet B, then apended below that would be data from worksheet C and then appended below that would be data from worksheet D.

Please advise on how I can do that.

Thanks
Exceluser101

 

[Robert Mika]

look here:
http://www.mrexcel.com/forum/showthread.php?t=62296