look for this item
Combine multiple sheets/
in the url
http://www.mvps.org/dmcritchie/excel/join.htm


--
remove $$$ from email addresss to send email
======================
"MS Office" wrote in message
...

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