Tab Name Equals Cell

Here is the basic code

Please Login or Register  to view this content.

To add the code
Right-click the tab of the target worksheet > choose View Code
Copy and Paste the entire code into the code pane, typically on the right side of the screen
Make any necessary changes to sheet and range references
Close the VB Editor

This code assumes the input cell is A1.