Help with renaming a sheet and referencing that sheet in a macro

Hi,

I am new to programming in Excel.

#1 I have created a macro that copies a sheet, and then takes information off of the sheet, and puts it on a summary sheet.
My sheets arealphabetically named... A, B, C, D, etc. and I want to be able to create new sheets, with the next letter in the alphabet. Can I make VBA reference a cell on a sheet to give the new sheet its name?

#2 Additionally, I run into a problem with referencing the new sheet to my summary sheet. Below is my current code. The problem is that the new sheet name "M" is hardcoded in there. I am not sure how to make this reference a new sheet with a new name.
Ex:

Please Login or Register  to view this content.

Any help is apreciated. Thanks