Add all C26 Cells from Different worksheets

[franswa3434]

Hi everyone,

I'm creating a pricing workbook that will have worksheets added and removed based upon the number of locations I'm pricing out. For example, if I have 2 locations, I'll have my initial sheet, and then a VBA button will create another pricing sheet for the 2nd location. If I have 10 locations, i would follow the same process.

My total pricing for each location is in cell C26.

How can I automatically add up the sums of each workbooks' cell C26 into a Total Cost worksheet, and do it in a way that changes automatically to the number of priced locations?

Thank you!

franswa3434

 

[franswa3434]

I think I got it.

I used the sum function, and put in a range (First:Last) and named my first and last sheets accordingly. any additions and subtractions within this range are automatically accounted for.

Thanks everyone!