Keep in mind that the Program1 tab will need to pull from the other 12 tabs each individually named by month. Once month August tab is over, than Program1 tab will need to retrieve data from the September tab (the Program will retrieve data from 30 unique cells). Than from October tab, and so on. I'm trying to avoid from having to update all the source of the 30 formulas every month.

Program1 - always the same
Months - 12 tabs with different data same format and location of cells

Does your formula below help with this or is there something else?

Thanks.