How do you combine data from 5 sheets to 1 sheet?

I have 1 workbook with 5 sheets.

What I want to do is combine all these data to 1 sheet.

How will I do that with Macro?

Columns in all my sheets are identical

My columns are

PHP Code: 

A          B        C        D         E         F
Market     Desc     Local   Profile   Item   Inventory Quantity 


Thanks!

You will have to explain better what you want. Do you want to add all cells A1 together. Do you just want to create a copy of each worksheet in the 5 files in the summary workbook? Or what?

Hi geng

If you wish to append the data from all worksheets into a master worksheet, see this thread http://www.excelforum.com/excel-prog...one-sheet.html

In you want to

add all cells A1 together

then look at this link http://www.excel-it.com/workbook_downloads.htm

Hope this helps.

John

The macro I have posted here does what you want, possibly with minimal editing. Set the SortStr to "Market" if you want to sort the data by the first column on the master sheet once it is merged.

Many Sheets to One Sheet