I have set up a workbook where each tab is a new day (Aug1, Aug2, etc.)
On each worksheet, I want to bring forward readings from the previous day,
but I don't want to reference the previous sheet by name or I have to change
all of the formulas on each sheet. How can I reference say, the number in
cell A1 on the worksheet named Aug1, and put it into cell A1 on the worksheet
named Aug2, then A2 would carry to A3, etc. Basically, I need to tell it to
get readings from the previous day without referring to the tab name. Please
help!