hi
suppose , there is a table in the sheet1 with headers column1,column2,... and cells A1, A2 and A3 are blank.
you can write a formula in A1 that is about table such as
=COUNTIF(Table1[TRUE],TRUE)

then you can write the following function in cell A2
=FORMULATEXT(A1)

at the end you can write this in cell A3
=MID(E5,FIND("(",A2,1)+1,FIND("[",A2,1)-FIND("(",A2,1)-1)

you will see the cell "A3" has got the name of table.

if you change the name of table manually in formula --> Name Manager then the content of cell "A3" will be changed.
regards