OP is looking for a formula to get a sum of values from multiple sheets and that works with the same functions (2016 version) that were used in the formula to get the sum of the values from each individual sheet. I attempted to help using functions available in the 2010 version, however that apparently isn't meeting the objective. You could probably skip down to post #13 in the thread to see specifically what the OP wants.
https://www.excelforum.com/excel-gen...orksheets.html