How to add all the values into one spreadsheet from multiply spreadsheets?

[Jana.Luo]

Hi there,

I have a few spreadsheets with the same formating and I need to add all the value into one spreadsheet. How can I do it quickly?

i.e. I have a few monthly data sheet. I want to consolidate all the data into one spreadsheet.

Thanks in advance!!!
Jana

 

[gaurav23]

Try consolidate function in Excel. The same can be found in Data Ribbon Data Tools Group.

 

[VoG]

Or perhaps this http://msdn.microsoft.com/en-us/library/cc793964.aspx

 

[Jana.Luo]

Hi Gaurav,

But that function only sum up all the numerical values. Actaully what I want to do is just put all the values(numberical and text) into one worksheet from other worksheets. I don't want to just do copy and paste into one worksheet type of work. Can you help me to get a smart way to do that? all the column titles are the same, just data are different. like monthly data.

thanks!!!