Automatic Change in Code

Is there any way, in which i can make my code dynamic?? For example, in a code written in VBA, there is a reference to particular sheet, say "ABC". If i change the name from "ABC" to "ABCD" from excel, the underlying code should change automatically from "ABC" to "ABCD".

I want to make my code dynamic..

I hope u get my problem... can any1 help me on this??