Copy-paste multiple workbooks into one

[giannisp]

Hello all.

I am new to vba/macro and would like your help.

I have 3 excels with different rows but same columns and would like to copy paste them into one "master" excel.

For example copy the rows from workbook A and when there are no more rows, start copying workbook B below the last of workbook A and etc.

I searched the web and found this: https://www.youtube.com/watch?v=62K3ACwC-V4 but after changing the code it still doesnt work.

Can this be done, currently (new job role) I have to copy paste the values every time manually and seems to me that it is dumb and there must be a better way.

Moreover, can this be done without having to open all the excels? only the "master"?

I look forward to hearing from you.

Thank you in advance.
Giannis.

[JBeaucaire]

A very common task, certainly.

'WORKBOOKS TO 1 SHEET STACKED
Here's a macro for collecting data from all files in a specific folder.

Workbooks to 1 Sheet

The parts of the code that need to be edited are colored to draw your attention.