I had a question on the command for a "previous worksheet". Basically I want to sum up a single cell from multiple sheets onto a summary page. Right now I know how to add cell A1 from Sheet1 to Sheet10, I'd type: "=SUM('Sheet1:Sheet10'!A1)" on a specific cell on SheetSummary.

My question is, if I insert another worksheet between Sheet10 and SheetSummary called Sheet11, is there a different command that I can type so that SheetSummary will automatically pick up cell A1 from Sheet1 to Sheet11? Is this possible in excel? If so, what is the command? "=SUM('Sheet1:???'!A1)"

Any advice will be helpful! Thanks!