I have 3 excel files. Each file contains 14 corresponding worksheets. For example, the 1st worksheet in file 1 contains similar data to the 1st worksheet in files 2 and 3.

My goal is to take each corresponding worksheet and transfer them into a new file, so that the new file will have 3 worksheets (the 1st worksheet from each of the 3 original files). Then repeat this with each of the additional 13 worksheets from each file.

The end result should be 14 new files, each with 3 worksheets.

Is this possible?