Can I link the name of a sheet to a cell within the same sheet?

M

MCJM

I want to reference the name of a worksheet to a specific cell within the
worksheet so that if I change a drop down box to look at differnt data, the
name of the worksheet changes.
 
G

Gary''s Student

Do you want to rename the current sheet based on the dropdown or just jump to
a sheet based on the dropdown?
 
Top