Hello Experts,

I need help with a VBA code that would copy and paste all the data from multiple excels (all have only 1 sheet inside a workbook) to only the master sheet (with the VBA code).

Step-1: Ask user to select the folder
Step2- Once folder is selected, it will copy all the excel workbooks data into the master sheet (Copy the data to multiple sheets in the master template and name it as per the excel workbook name in the folder).

I tried the get data option in Excel, but it only allows me to combine the sheets and not place it in different different sheets.