Update Cell text (ie title) based on Worksheet location

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.

Thanks for the advice. That was not quite what I was looking for. I am not looking for the cell to reference the worksheet name. I want to use Cell A2 as a title cell for the worksheet. I want each worksheet to be titled "Exhibit" then the # as an example the first worksheet I want to be be titled Exhibit 1, the second Exhibit 2, the third Exhibit 3, etc. With 50+ worksheets it is very time consuming to manually renumber the titles if I add a new worksheet or move the worksheets around within the workbook.