Need a VBA that will combine all the worksheets of several workbooks

Hi all,

I am using Excel 365 and I am looking for a VBA that would do the following:

I have a folder called "rt1520" and it contains several Workbooks (all of them have a single worksheet therein called "Sheet1"). I need to combine all the "Sheet1" of these workbooks into a single worksheet in another workbook. Basically, the VBA will need to append all the data in the workbooks into a single worksheet.

I guess it is possible to do with VBA but as I am total newbie regarding VBAs, any help would be appreciated.

This type of question seems to come up a lot, I've attached a fairly generic macro that should allow you to do this.

It's a standalone file that takes the folder name and output filename as input.

It will append all the data from the nominated sheet from each file in the folder into a single file.

Originally Posted by gijsmo

This type of question seems to come up a lot, I've attached a fairly generic macro that should allow you to do this.

It's a standalone file that takes the folder name and output filename as input.

It will append all the data from the nominated sheet from each file in the folder into a single file.

Many many thanks! Beyond what I expected! Works like a charm.

You are most welcome