I have a budget summary sheet that summarizes values on a month worksheet using sumif. Example “=SUMIF(June!H6:H129,$C39,June!D6:D129)”. Instead of referencing “june”, I would like to have a drop down list of months in L1 and the formula would refeence that month selected would then return the values. Each tab is a month.

I’m working on a spreadsheet and need to find a way so that when you click on a dropdown in a cell in a particular column, it asks you to choose 1 item from each of 3 different lists, and displays them in that cell.