I have a summary worksheet in a workbook that will be updating with data from many different worksheets. Each time I add a worksheet I will need to add a cell reference on the summary sheet that will update with the worksheet name, even if I make changes to the worksheet name in the future. Is there a formula that I can use for this?
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.