I want to refence a cell in all previous sheets in a workbook. The problem is
that I'd like to paste the formula to other sheets and still have it refernce
all previous sheets to that sheet.

For example, on sheet 5 the formula would refence cell A1 in sheets 1, 2, 3,
and 4. When I copy and paste the formula to a cell in sheet 9, I want it to
automatically expand the sheet range to now reference A1 in sheets 1, 2, 3,
4, 5, 6, 7, and 8.

Is this possible?