Pull Data from Specific Cells based on Date

Hello,   I'm working on creating a reusable performance tracker for my company that tracks sales of different criteria New Activation (NAC) vs. Upgrade (HUP) based on company.   I have several sh...