The only way I can think of doing this is to run a macro post or pre reload, that cycles through each sheet and uses GetProperties.Name, and creates a variable per sheet with .Name in it. On your sheet you can then just refer to the variable for the current sheet.
I could write this code for you however I'm not in a position to do it right now
How about a macro that is fired for each sheet's OnActivate event that sets a variable containing the concatenated document /sheet names? This variables contents is then displayed in a text box.
The OnActivate event is not fired on inital document load with the IE plugin, so you need to have the variable set to the name of the sheet that is initially displayed.
