Reference cell in the "next" worksheet (regardless of name)?
I need to insert a new worksheet into a bunch of existing workbooks and
reference a few cells in the next worksheet in the workbook. Unfortunately,
the worksheets do not have consistent names.
I'm looking for a formula something like ='NextWorksheetName'!F7. My new
worsheet will always be inserted before the existing worksheet, and will
always refer to the same cell in the existing worksheet.
Any suggestions on how to do this?
Thanks!
|