Extracting the sheet name only (as a string) from a formula to another cell

[aperrin6]

Actually: compile error: can't find project or Library. And it highlights the word Left