Read sheets from different workbooks and copy all content from a certain sheet

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!

Hello,

first of all: thank you very much for taking the time to answer me.

Unfortunately I receive an error:

Please Login or Register  to view this content.

at the line:

Please Login or Register  to view this content.

Do you know how to fix this?

Try...

Please Login or Register  to view this content.

Hello,

I get:

Please Login or Register  to view this content.

at

Please Login or Register  to view this content.

Hi !

You just forgot to update the files path …

Originally Posted by Marc L

Hi !

You just forgot to update the files path …

Hello,

in this line:

Please Login or Register  to view this content.

?

Of course : where is located the workbook to open ? …

i think what he is saying is the following:

Please Login or Register  to view this content.

you need the path to the R83_Com# file

I've entered the path of the files and now we are back to:

Please Login or Register  to view this content.

Try this...

Please Login or Register  to view this content.

Hi,

now I have:

Please Login or Register  to view this content.

at

Please Login or Register  to view this content.

Try...

Please Login or Register  to view this content.

Awesome, works like a charm! Thank you so much for your effort!

We both learned something. Glad to help!