Loop specific VBA code for every 15 Rows upto 5000 rows of a sheet

Hi AB33,

Thank you very much for prompt support. Actually i am looking for a different solution. Probably i did not provide proper requirement. Please find enclosed template. I want to copy "A1:N1" and "A4:N4" upto say 5000 rows for every interval of 15 rows with out disturbing data of any other rows. In existing macro (commented in this sheet), i am fetching data from some other sheet. Initially i am clearing all the data so that my data in Final format is always fetched based on latest
information in the other sheet. Secondly is there any way to retain the color formatting of entire sheet?

Kindly suggest suitably. Thanks once again for prompt support.

Regards,

Narasimharao