[sro]

I have sheets of data in a workbook that I set up each day in a month (1 sheet for day one then I add sheet 2 for day 2 etc) Some sheets may contain more than one day (eg - "JUN 9 10") Each day's sheet is copied (new sheet tab to the left) from the prior day. I pull the cumulative total from the prior sheet always from the same cell. Right now I have to change the formula to refer to the adjacent sheets name. I would like to be able just to have the formula pull the value from the "adjacent" sheet (obviously always the one to the right). That way the formula would always work for all sheets after day one. Is there a way to do this? Thanks