Hi

I'm building a sales tracker for my company and need to create a function
where the "administrator" can rename a specific range of tabs according to a
list of staff by clicking on a button.

There are ten "staff" tabs (named CA1 through CA10) which i need to control
by the manager keying the name of the member of staff into a sheet called
Staff Details and then pressing a button to refresh the names. I simply
cannot figure out how to rename a sheet according to a central reference...
anything i try will not work!