Compile Different sheets in one sheet

[Bijan1231]

I want to compile the no. of sheets in one sheet of the same workbook
having same column name and similar data.

 

[Anne Troy]

Try this:
http://www.officearticles.com/excel/sum_the_same_cell_in_multiple_microsoft_excel_worksheets.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com