Hi,

I have three workbooks that have identical structures or formats. I wanted
to summary to data from them into another workbook.

Ex: I would like to sum [Monder.xls] sheet1!C5 +[Teacher.xls]
sheet1!C5+[Student.xls] sheet1!C5 into [Total.xls] sheet1!C5.

Actuality, I would like to sum the value of C5 of Monder, Teacher and
Student workbooks into Total workbook.

I tried to use Consolidate function; however, the Total workbook was not
updated after I changed the C5 value of Monder workbook.


Please help
Chi Huynh