A variation on Gary's suggestion, in case your monthly totals aren't all in
the same cell addresses: give each total a range name, MonthlyTotal

Then Gary's formula could be changed to

=Jan.xls!MonthlyTotal + Feb.xls!MonthlyTotal + Mar.xls!MonthlyTotal.....




"Cindy" wrote:

I would like to take separate workbook totals and create a workbook that will
calculate all of the totals inputted without having to manually go into the
workbook and input the totals.
Example if i have monthly total in one workbook say Feb and in another
workbook I have March's monthly total and so on, how would I take those
totals and have them automatically transfer to another workbook that would
give me year end totals?