I have attached the workbook I am working on. The 1st 4 sheets are products. The 5th-8th sheet are querys that return data from our software. I have gotten the first sheet to work exactly how I want it. In the top right section of sheet 1, I pull historic sales data from the querys using sumproduct. When I transfer this formula over to sheet 2,3, or 4. I am getting no results. I believe it is referencing everything the same, but something isnt working.

Also, if anyone has any ideas to clean my formula up I am open to it. Right now I cannot drag the formula down or across or QTY it returns gets thrown off.

Thanks for any help

forecast.xlsx