Copying Multiple worksheets in Multiple workbooks to one single workbook

Instead of the screenshot, it will be good if you can attach a sample workbook or workbooks so that we can test your code along with the file.

I am not sure how I would attach a workbook. Do you mean just what I have on my screen shot but multiples of them? I am okay giving out the actual workbook

To attach a file to your post, you need to be using the main 'New Post' or 'New Thread' page and not 'Quick Reply'. To use the main 'New Post' page, click the 'Post Reply' button in the relevant thread.

On this page, below the message box, you will find a button labelled 'Manage Attachments'. Clicking this button will open a new window for uploading attachments. You can upload an attachment either from your computer or from another URL by using the appropriate box on this page. Alternatively you can click the Attachment Icon to open this page.

To upload a file from your computer, click the 'Browse' button and locate the file. To upload a file from another URL, enter the full URL for the file in the second box on this page. Once you have completed one of the boxes, click 'Upload'.

Once the upload is completed the file name will appear below the input boxes in this window. You can then close the window to return to the new post screen.

Here are a couple sample workbooks. I only want to pull of the Corr2 sheet for this one then I will setup another one to pull off of the Corr3 sheet.

I seem to be close with the above code. However, I am noticing that it isn't pulling all of the data from all of the files within the folder in which they are and am not sure as to why. I notice that when the program itself is running it isn't pulling the files in order from start to finish that is it bouncing around a bit.

I just confirmed it isn't pulling the files in order from how they are in the folder. Does anyone have any idea as of why? also it didn't pull any information from the very last file that it opened up. It pulled the file fields but not the data that was in the fields. The files are dates from the beginning of the month to the end. I would have assumed it would pull them in order from the first file in the folder till the last. However this is not what is happening.

Alright I have it all figured out except for one thing. Instead of copying all the data I am pulling into a new workbook I want to open it up in the one I have the macro running in. Does this make sense? Any help would be great.

Just some observations on your code.

Instead of this -

Please Login or Register  to view this content.

You can ask the user to navigate to the path where the files are saved. This can then be assigned to MyPath. That way you do not have to check if the user has put the last "/". (However, if its too difficult to get this done, you can continue with the above).

I guess this is where your copied data is getting stored. -

Please Login or Register  to view this content.

You can change it to refer to your macro workbook like -

Please Login or Register  to view this content.

Yes that is where it is being stored. How do I change that to refer to my macro workbook? I figured everything else out and it appears to be working properly. Even figured out how to sort the new incoming data. Just trying to figure out how to have Excel put a space in between two fields when one sort stops and the other one begins.

If

Please Login or Register  to view this content.

doesnt work properly, then use

Please Login or Register  to view this content.

What do you mean by space? Row to be inserted or column?

A row due to the way I am sorting data out. The only question I have is I have a lot of other code about the new workbook in the original. When I change the BaseWks=thisworkbook Do I need to change any of my other programming after that line?

If you are referring to the new workbook as BaseWks throughout, you do not have to change it.

To insert a blank row, just add 1 to this code line -

Please Login or Register  to view this content.

Change it to -

Please Login or Register  to view this content.

This will leave one row and then copy the next file's data onto the next row.