Read sheet with same name from multiple excel files

[aparna0208]

Hi,

I have few excel files in a folder which includes multiple sheets. The one sheet that is common in all files is Output. Is there a way to read all excel files in that folder and output records from the "Output" sheet in all the files?

[mceleavey]

@JacobGFMR ,

on each bespoke tool click on the "Questions" tab. Make sure you select the fullpath field.

M.