Is there a way to have the worksheet tab names reflect the same name that is
in another worksheet and another cell without having to change (18) worksheet
tab names. The cell and worksheet would remain the same, however occasional
the name in that cell would change (as per new release's, P1, P2, P3, etc)
and I would like the tab to automatically update the new name.

Any thoughts

Thanks
Frank