Hi, I am trying to create a summary tab that will find and sum values from a variable number of sheets based on two criteria. These criteria are a revenue identifier (rows) and time period (columns). On all the sheets that I am summing, the columns and rows are not uniform, hence the need to locate the intersection of the criteria on each before summing. The number of sheets to be summed also varies so I was planning on using two blank sheets with the sheets to be summed in the middle. I was attempting to use a combination of sumproduct, sumifs, and indirect but am having trouble getting there. I searched for a while but could not locate an instance where this was addressed.

I am new to posting here but have lurked for a while and appreciate all the insight this site has to offer. Thanks in advance for the help.

Thanks!