Hi Issam Mansour,

You can use ".Activesheet.name" Property to give new name to all sheets.
You can easyly find "Activeshee" of current work book.

Thanks & Regards
Shalabh Singhal
India