How to read each excel in a folder

[Srini84 (Srinivas Kadamati)]

@siteltower

Check below for your reference

Looping through all excel files in a folder

Hi, I have 4 excel files in a folder . first 3 are input files and 4th is the output file. I want to loop through all the files in a folder, copy data from sheet1 of all files and append in the 4th file (name: “Output.xlsx”) present in the same folder. can anyone help here

Thanks