|re: "But it is required to do through Excel VBA"|
Keep in mind that we can't see your speadsheet from where we're sitting, so you have to supply lots of detail so that we can understand your task.
re: "I am able to do renaming in English to English"
Are you already using VBA to do this? If so, please post the code that you are using.
Before you post any code, please click on the next line and read the instructions on how to post code in this forum.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.