Combining large sets of data

I have a 2 million line file that is broken up into 5 files. Each is in a folder by itself. There are identical file/workbok names in each folder. I would like to know how to combine these files/workbooks without Excel overwriting, or not have to copy and paste into each file to create a singe file for each file/workbook name. Can you assist?

Is the data in each standardized? Are you just trying to copy all of the data in each into one continuous stream of rows?

thank you for responding so quickly.
I have folder 1 that has workbook abc in it, and folder 2 has an abc file as well. I want to combine the abc's from these different folders to make one abc file. Thanks again.

I'm asking what they look like. Are you just trying to get the rows from workbook 2 under the rows in workbook 1, etc?

I wrote a pretty tragic piece of VB that can take all Excel files in the same folder, copy all of their tabs into one workbook, and then it copies all of the worksheets into one worksheet of continuous rows.

Would this be of assistance to you?

The macro I used did not make tabs. I just made workbooks in each folder. If I put them in tas, it would be over 250 tabs. I would like to just be able to have one folder with 250 files in the end. I hoe I am explaining this ok. Thanks again.

Ok, now I'm confused. In your first post you said you have 5 files and that you need them combined.

In your last post you said you want to have 250 files when you are done. I thought you were trying to have less files when you combine the data, not more.

so, say I have this exact data in two separate folders. How can I combine one file into the other without overwriting or copying an pasting for a ton of files. Thanks.

SVC 151670 S
SVC 151670 S
SVC 137333 S
SVC 145701 S
SVC 137333 S
SVC 145701 S
SVC 137662 S
SVC 137461 S
SVC 137696 S
SVC 6001-2610 S

Yes.The files are in different folders though. does that matter?

You could run it five times I suppose.