consolidation of multiple sheets' data, need to find other option than pivot

[salmanyammani]

I have some data on multiple sheets (same format) and I need to consolidate it on one sheet , need to explore an option other than pivot table.On summary sheet data must be in order i.e without blank space.

 

[VoG]

See if this helps http://msdn.microsoft.com/en-us/library/cc793964.aspx