I have a workbook with 75+ sheets. I have a title in cell A2 of each worksheet titled " Exhibit" #. I am looking for a way to automatically fill in the # based upon its location (Worksheet Index?). For example if I add a new worksheet after Exhibit 25, I'd like to have all of the title cell in the subsequent worksheet to update automatically. So the cel that did show Exhibit 26 would now show Exhibit 27. Any help is greatly appreciated.

I am new to VBA, so a non-vba solution would be great. But I can do a small amounts of VBA, so if the only way to do it with VBA, I am comfortable trying.