bulk update individual cell references at the same time.
I have a scorecard that pulls data from several other spreadsheets, all of which are specific to different years. With the new year approaching, I aim to generate new copies retaining the same workflow and linked sheets. Is there a method to duplicate all sheets with new year specific names while maintaining the existing document linkage? The only way I see is to go to each cell and update hyperlink manually to the new sheet but I have around 1500 cells that are linked to different sheets capturing data. Is there a way to do this update in bulk action.
Sorry if my questions sound confusing. Thank you in advance.