how add different workbooks of excel into one

[moizs]

I have different workbook of excel and each workbook has one sheet of data, i want to add all the workbook in single workbook.

 

[bobhc]

Good day mozis


A frequently asked question and one with many answers via the search box top right


http://chandoo.org/wp/2010/02/19/excel-consolidate-data/

 

[nazmul_muneer]

Dear moizs,

You can get help by using 3D References. Please find the link.

http://office.microsoft.com/en-us/excel-help/create-a-3-d-reference-to-the-same-cell-range-on-multiple-worksheets-HP010102346.aspx


Regards,


Muneer

 

[bobhc]

I don't think moizs wants to reference cells across multi sheets, I think he is after combining multi workbooks/sheets into one workbook