perhaps the Data Consolidation or Pivot Table across multiple sheets would be place to start with before using sumif or sumproduct