Good day everyone,
I have 40 excel files and each file has around 16 worksheets. The 40 file names are variable from time to time (Example; now file names ZHA1 to ZHA40 but after one month file names will be changed). In addition, I have one more file (its name is Collection) to collect data from the previous files.
All excel files have same path.
I would like to copy data with range (A4:I43) from sheet no. 14 of all the 40 files and paste data to collection file. (Example; the first file will be pasted on (A5:I45) and the second will be pasted on (A46:I85 …)