Hello Experts,

I am using Windows XP/Office 2003 and have the following problem:

I have a Time Sheet Workbook with several sheets starting from 01 to
050.. (the number of sheets will vary)

In this workbook I have a Sheet Name Employees as follows

Column A
Row 1 Name
Row 2 Mr. A
Row 3 Mr. B
Row 4 Mr. C
...
...

etc etc


I wish to achieve the following through a macro

1) Rename each Sheet viz 01, 02. ..till end with the First Name from
Employees Sheet eg. 01 becomes Mr. A, 02 becomes Mr. B.. and so on till
the last employees name.

2) And copy Name of Employees in Address B5 .. means the respective
sheet name will also be shown in Cell Address B5..

Can any body give me a clue or suggestions please.

TIA

Rashid