Copying data from one sheet in first excel file to another sheet in second excel file
I have a an excel file where I have two columns containing the file names (see example below). And each of the files just have one sheet. I want to copy the entire sheet from the file in the first column to a new sheet in the file in the second column. So, the output should be the files in second column should have two sheets (one original and one copied from the file in first column). I also want to rename the sheets to the file names.