I have a workbook with 35 - 40 sheets - the total from those individual sheets gets put into a summary sheet. The problem is, I need to name each sheet with a persons name and have their total in a summary sheet. How can I change the name on the summary sheet (cell as well as the total) if the name of the original sheet changes.
Thanks
Mike
Thanks
Mike