Create a single sheet from many sheets

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

Try this: http://vbaexpress.com/kb/getarticle.php?kb_id=151
************
Anne Troy
www.OfficeArticles.com

"MS Office" <mantrimukesh@hotmail.com> wrote in message
news:OaXZSB0sFHA.1168@TK2MSFTNGP10.phx.gbl...
> 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
>

Hi MS Office

See
http://www.rondebruin.nl/copy2.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"MS Office" <mantrimukesh@hotmail.com> wrote in message news:OaXZSB0sFHA.1168@TK2MSFTNGP10.phx.gbl...
> 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
>