Thanks & Regards, To place data from multiple CSV files onto a single worksheet, choose Data from the selected sheets to one sheet.
Worksheets('Master') folder_path = 'C:\Users\Jie\Google Drive\(YouTube Folder)\_To Upload\Macro to combine CSV Files into One\' my_file = Dir(folder_path & '*.
Paste the following code into the powershell window that pops up and hit enter. Open the Excel files and in the menu bar, click File, then Save As.