GTretick
Member
I am creating a file where users will use an input worksheet to enter in some key data each day. Each day will have it's own worksheet but not necessarily one for each consecutive day (days can be skipped). As worksheets are copied and renamed to create a new day, I would like a summary worksheet to recognize its creation and pick up some key data.
I've included a dummy workbook with basic direct link formulas to show what is being picked up. (Highlighted in yellow in the workbook). Linking each worksheet manually as it is added is not the solution I'm looking for.
I've contemplating pre-populating the workbook with multiple worksheets but that is not my ideal solution.
Finally, I would like the calculation strain on the document to be as minimal as possible as extended waiting time to recalculate as data is entered is not desirable.
Does such a solution exist? I'm open to moving layout of cells around if that happens to make the solution easier
I've included a dummy workbook with basic direct link formulas to show what is being picked up. (Highlighted in yellow in the workbook). Linking each worksheet manually as it is added is not the solution I'm looking for.
I've contemplating pre-populating the workbook with multiple worksheets but that is not my ideal solution.
Finally, I would like the calculation strain on the document to be as minimal as possible as extended waiting time to recalculate as data is entered is not desirable.
Does such a solution exist? I'm open to moving layout of cells around if that happens to make the solution easier