VBA error in excel 2013

I've recently upgraded to excel 2013, and some VBA code (below) which worked fine in Excel 2007 now seems to return errors:

Please Login or Register  to view this content.

The specific error it returns is "run-time error '1004'", and I've been able to debug the error to the line of code ".Name = Sheets(1).Range("C" & i).Value"

Background:

I currently have a master sheet (Sheet 1) containing about 200 codes (C2:C201), with 200 individual sheets (sheet 2, sheet 3,..., sheet 201) in the workbook I want to be renamed, edited individually, and have their separate web queries updated in each sheet.

The purpose of the code is to have VBA rename sheet2 from the list (it would be from c2, "AAA"), then within sheet2 (now renamed AAA) I would like the new name of the sheet to be entered in cell H1. I have web queries in each of the sheets synced up so that when H1 is changed, they automatically update from the web, so the vba pauses until all the query updates within a given sheet are finished, and once the sheet has updated, move on and do the same thing for sheet3, sheet4, sheet5, etc. pausing each time to let each sheet update from their individual web queries after their names have been changed.

Any help is very much appreciated, even if it is just some advice on perhaps why the error is now occurring, or why it occurs on that specific line.

Thanks

The first sheet is called Sheet1, and I want to rename sheet2 - sheet 201 using the three letter codes in the C column in sheet1.

I was kindly given this code on a forum (possibly this one) a while ago, and it worked well in excel 2007, but upgrading a complex system is never as smart as it seems.

That seemed to have helped, thanks.

Just for my own future reference, any idea what the error refers to?