The following formula returens the name of the worksheet.
returns information about the formatting, location, or contents of the upper-left cell in a reference.
And the syntax is CELL(info_type,reference).
Filename is an argument for info_type and it's stands for (including full path) of the file that contains reference, as text. Returns empty text ("") if the worksheet that contains reference has not yet been saved.