Data from multiple sheets in one

[Cristy]

Hi,

Someone can help with a code, that move data from multiple sheets in one (the empty sheets must be deleted), all this sheets are in the same file. The head of table is the same for any sheet. The result is one sheet with data from all sheets one under another.

Thx

 

[VoG]

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