Insert name of worksheet into cell of another worksheet-Excel 2013

Is it possible to pull the name of worksheets into the cells of another worksheet?

For example, I have three worksheets, named Test A, Test B and Test C. In a fourth worksheet, I'd like to automatically pull those names into three different cells so that they read Results from "Test A", Results from "Test B", and Results from "Test C".

Thanks!

You can do something along thses lines:
="Results from " & MID(CELL("filename",Sheet22!A1),FIND("]",CELL("filename",Sheet22!A1))+1,99)
but of course, the bit in red is the result of you selecting a cell while composing the formula. However, should you later change the name of the sheet it will automatically reflect that change.

Perfect! Thanks!