Sum quantities of unique items across multiple Excel sheets by consolidating data and using UNIQUE with SUMPRODUCT to aggregate totals.