need help to arrange my data from one file multiple file in A column. is it possible by macro ?

[geethanjali63]

Dear MVP's,Any one can help me on macro. I need to cut the data from source file's A column to destination file A column. Repeat the same step to all the file with in a folder, other than source file.If first destination file having data 7 rows, then cut data from A2 to A8 cells from source, save and close.then next file 15 rows, now A9 to A23 cut and paste in destination file save and close.Repeat same up to last file in the same folder. finally save source file close.1. Source File:I have one set of data in master file A column (18 digit alphanumeric) with header of Carton Id, data may be 100000+ rows. each cell unique data, no duplicate.File name Examples :carton_numbers2. Destination File:I have multiple files (1000+) in same folder. A column is blank. Column B to Q have data. Some times Number of Row will be differ in each files. May be 2 rows to 150+ (Row 1 is header). File name Examples :1243973,1243973 - Copy,1243973 - Copy (2),1243973 - Copy (3),...........