Is it possible to enter a formula in the format of, "='Sheet1'!A1" and then
just click and drag and have the formula automatically go the the next sheet?
i.e "='Sheet2'!A1" instead of "='Sheet1'!A2"