I think there is no way (may be I don't know) to show Sheet name (atleast with QV built in functions), one work around is make sheet name as Sheet ID
QV does not have such function to display sheet name but there is a function to display document name (DocumentName()). If you required sheetName,use variable as suggested above.
1.Create a variable vSheetName
2.Assign a value to a variable ex: vSheetName = main
3.Go to sheet properties > Title > =vSheetName
Add the same variable to Texbox to dislay Sheet name
The only option i can think of, is to include the metadata from the app like this:
[Sheet/SheetId] AS SheetId,
[Sheet/Title] AS SheetTitle
FROM Test1.qvw (XmlSimple, Table is [DocumentSummary])
Your expression in the TextObject would then look like this:
Unfortunately this will require a reload, whenever you add a new sheet.