Is there a way to pull the sheet title into a cell within the sheet?
No, you would need to type it in.
