thank you @NoSparks

Its working but i notice some problems if i insert a new row the data in the master list will show in column X row 9 i try to adjust the numbers in the code but nothing happens.