Recap Sum function for multiple sheet

[stormania]

Dear Excel Master

Kindly help to get formula sum in one sheet for recap from multiple sheet.
I am attach the file and my formula is sum one by one sheet,sometimes i missed to sum sheet in different column.
Maybe any formula to sum multiple sheet and avoid missed column to sum
Thank you

 

[AlanSidman]

Look at this link http://www.officearticles.com/excel/sum_the_same_cell_in_multiple_microsoft_excel_worksheets.htm

=sum(A:M!A8)

 

[bosco_yip]

1] Giving 2 formulas in sum multi-sheets per code and per sheet.

2] See attached file

Regards
Bosco

 

[stormania]

Thanks all master..its works