You need to give us more information.

What is it you are trying to do?
Why do you need a macro?
Why not just reference the cells in one worksheet from the other worksheet?

Regards,
Fred

"vic patel" wrote in message
...
i like to create one worksheet which link to other 4 worksheet.after that i
would like to change file name.i need your help.please my be you can.