Hi,

I have a workbook with 20 sheets. All these sheets have the same coloumns.
To make a pivot table, I want to merge all these sheets into a single
sheet.Is there a quick way?

Thanks in advance
Mukesh