VBA Function to Return Worksheet Name from Code Name

I tried to find simple function to return the worksheet name from a Code Name. As I was searching, many said I...