i have a large number of excel workbooks, name "file 001", "file 002", ... up to file "384".

in each of these files, a worksheet named "Sheet1" contains data in this range A1:K1.

there is another workbook named "central file", it contains a sheet named "Central sheet".

i need to have a macro in "central file" which can do the following:

copy the contents of A1:K1 from each file ("file 001", "file 002" ... up to "file 384") into a new row (row 1, row 2 ... up to row 384, respectively) in the corresponding columns (A to K) in "central file".

can you help me with a macro code, please?

TIA.