This question already has an answer here:
I have a workbook containing monthly data sheets (sheet 1="January", sheet 2="February", etc.). I also have a "Data Display" sheet where I have endusers select the months summary they would like to see. I'm using a data validation box for user to choose the month. Based upon the end user's selection, I want to have my formula adjust this formula to the appropriate sheet:
All of my monthly sheets have the same column assignments.