How to copy data from multiple sheets to one sheet

[Sudheer777]

Hello All,

I have 30 sheets in a workbook. I would like to create a visualization using that data. In order to create the visualization, data should be in a sheet.

Can you please help me go copy the data into one sheet.

It will be a great help.

Regards,
Sudheer

 

[pecoflyer]

Google is your friend http://www.rondebruin.nl/win/s3/win002.htm and http://www.rondebruin.nl/win/addins/rdbmerge.htm