Copy from one workbook and Paste in New TAB of Master workbook

Try adding this into the loop:

Please Login or Register  to view this content.

Ok...I added

Please Login or Register  to view this content.

Following happened: It opened the workbook, moved the data from workbook(1), copied and saved the data from workbook(2) over top of the workbook(1) data and then failed on the statement:

Please Login or Register  to view this content.

Addition information: The workbooks that are being opened, copied, saved, and then closed will each need their own separate worksheet. I am thinking I am going to need a "for loop" to make this happen, or is there a simpler way to Open the workbook, copy the data, paste the data in its own worksheet on the "master workbook", save the opened workbook, and then finally close the workbook?

Can you attach the workbooks, and I'll try it on my machine?

Try getting rid of

Please Login or Register  to view this content.

I think what is happening is that the move statement removes all data from the source workbooks, and it becomes empty. Since the workbook is empty, the save and close statements fail.

The way the code is written, it will automatically create a new worksheet for the data being copied. One sheet for each file. There is really no need to save the files since you're just copying and pasting from them.

Let me know if this fixes the issue.

It's the same as the other worksheet, just remove the two lines from the code.