Hello,

I'm having five workbooks called like this:

R83_COM1.xlsx
R83_COM2.xlsx
R83_COM3.xlsx
R83_COM4.xlsx
R83_COM5.xlsx

Each workbook has three sheets, which have the same names:

ComSheet1, ComSheet2, ComSheet3

I've created a workbook called R83_ALL.xlsx with the following sheets:

COM1, COM2, COM3, COM4 and COM5

Now I want to copy the "ComSheet2" sheet from the five workbooks to R83_ALL as follows:

"ComSheet2" from R83_COM1.xlsx to sheet "COM1" in R83_ALL.xlsx
"ComSheet2" from R83_COM2.xlsx to sheet "COM2" in R83_ALL.xlsx
"ComSheet2" from R83_COM3.xlsx to sheet "COM3" in R83_ALL.xlsx
"ComSheet2" from R83_COM4.xlsx to sheet "COM4" in R83_ALL.xlsx
"ComSheet2" from R83_COM5.xlsx to sheet "COM5" in R83_ALL.xlsx

Do you know an easy to program this?

Thank you very much for your help!