Yup running the code on all data sheet. The code you gave in post 13 is perfect just need to resolve the (i)issue of data being not getting pasted to 2nd sheet (ii) after finishing everything naming the a1 to g1 as given in post 14