sheet 1, cell (n#) and sheet "N" tab name

G

Guest

This is a bit complicated.

1. GIVEN: A multi-sheet workbook, sheet 1- sheet #.

Need to enter on sheet 1, Cell A#, a "Tab Name", where entering this
changes the Target Sheet # Tab Name to what I entered on sheet 1.

Can this be done?

if not, is the following possible?

2. Reference the name of Sheet # tab name on Sheet 1, Cell a#.
 
M

Max

Why not just right-click on the sheet navigation controls at the bottom left
corner, just to the left of the 1st visible sheet tab? That'll give you a
pop-up menu to go to any visible sheet.
 
Top