How to consolidate all the files into one files with different sheetnames

How to consolidate all the files into one files with different sheetnames. In a folder, there are 21 files ,how to consolidate them into one file which has diff sheetnames

@anjani_priya

  1. For each file in folder
  2. Read the data and then write to different sheets using write range…change sheetnames as per file name or numbering or as you need

Cheers

Hi @anjani_priya

Please check the below thread

Regards,

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.