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