Good afternoon,

Each month I recieve a workbook with 14 tabs. Each tab has a name of Name - Date, example:

Joe - 30-09-2010
Matt - 30-09-2010

Following month:
Joe - 31-10-2010
Matt - 31-10-2010

I would like to build a macro which removes the date and just leaves the name, e.g. Joe. I think there is 2 ways to do this either:
i. Remove the date with a RIGHT command
ii. Create a list and have the sheets renamed based on order

My VBA is very basic. I was wondering if anyone could provide me with some help please