Thanks Aqib for the suggestion,

I am using links instead of copying, but as any changes done in any of the
10 different excel workgroup which are are of older version than master
workgroup the Update doesnt return correct updated value, instead returns the
old unchanged value or gets #ref error.

Regards,
Sonbarse :-((

"Aqib Rizvi" wrote:

Most simple way is to link the columns to your master sheet, instead
of copying. Each time when you open the worksheet select Yes to
update links and that would update your master.

AQIB RIZVI