It looks to me like you need to use Excel Pivot Table and Named Range. This would require excel to use a dynamic range