sheet consolidation

[KARUNANITHI]

Hi Team

I have reporting file, it contain 5 sheets, each sheet contain data. Is there any option i can conslidate all the five sheet data to new single sheet,

Thanks
karuna

 

[VoG]

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