Naming the Tabs

Hi All,

Is there any way to rename the tabs instead of actually typing. I have a different sheet for each member of my team. Let us say from Member 1 to Member 10. Is there a way where we can put these names somewhere and the tabs will be named automatically. Just thinking.

Please let me know whether it is possible or not.

Cheers-
Inayat