I have a master (named Country) sheet which is taking data from another sheet
(named City) in the workbook through the links. Every week i am getting an
updated city sheet from my data entry operator. I want to replace the old
city sheet with the new city sheet with the same name. But when i delete the
old sheet and copy the new sheet with the same name, the master (Country)
sheet is showing #REF! in its cells.

Is ther any way i can accomplish this so that i can save my time from copy
and paste?

thankx!