VBA merge worksheets in a folder - each file in a column, multiple worksheets below

It would help if you could load a sample file, as per the yellow banner above.

Sample file attached.

Give this code a try

Please Login or Register  to view this content.

Thanks for reply. This works great for stacking the data in a single column. I am looking for more of a combination of the two approaches. Everything from file one goes in column A, file 2 goes to column B. But the data from each worksheet is stacked in the column.

So your saying that there are multiple worksheets in each workbook? Which worksheets do you need to copy over, all of them, or just the first two, or just certain named ones, or all but not one with a certain name? It's not clear from the sample workbook.

That is correct. There are two worksheets in each workbook that need to be copied over one above the other (call them sheet Content and Progress). Each workbook would then be in a different column.

Alright, here is an update

Please Login or Register  to view this content.

Thank you for the update. It works great. There are a few adds I would like to make -

- The two worksheets (content/process) have different ranges to pull from
- The worksheet names are four words separated with _ (i.e. A_B_C_D). Can it pull the worksheet name and split up the values? So A would be row 1, B row 2, etc)
- Rather than copy into a new worksheet starting in column A, I would rather it pull all the data into an already existing worksheet in the current file (that has the VBA code) starting in column B (so that I can have column A prepopulated)

Thanks again!

We need to see the new file setup. Where are the ranges on the sheet?

Call it B2:B4 on the content sheet, B2:B6 on the process sheet. The row value will likely change as I finalize the pull in data.

The data being pulled is already in column B. Please create a sample workbook that is representative of your new requirements, with before and after sheets

Updated with attached file.

The file does not align to the description in post #9.

Updated file attached.

This seems to work very well, thanks. The only issue I am seeing is that the file names that it pulls in (A_B_C_D) need to be of the files being merged in, not the name of the current file open. For example, A, B, C, D will be different for each file pulled.

Updated

Please Login or Register  to view this content.

Seems to work great! Thanks again for all of the help.