Copy Sheets from multiple workbooks and add them to master workbook

Hello

I have a folder containing multiple .csv files. The .csv files all contain 1 sheet with data in columns A,B,and C. I would like to be able to copy each sheet from every .csv file into 1 master file. Each files sheet is named differently. I have found multiple posts on here that relate a little but I cannot seem to adapt them to what I need. I am using Excel 2010.

The only thing I would like to add is that the directory of where the files are located I would like to be able to change. This file will be given to many different users and being able to select the desired location of the files is a must.

Help would be much appreciated. Thanks

Do you want the sheets to be copied as a whole? Or do you want the data to be copied into 1 sheet in the master file, 1 below the other?

If its the former, do you want the sheets to be named as per the file name?

Try this code

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button