I have a workbook with sheets labeled for each day of the month 1-31. The form is the same on all the sheets. I need to retrieve data from each of these sheets and put in a data sheet for charts. I use the formula ='1'!b31 meaning sheet 1 cell b31. however when I want to copy this formula to be ='2'!b31 It will copy ='1'!b32. What am I doing wrong? I need to retrieve all the cell b31 from all 31 sheets.

Thanks
JBC