read same sheet from xslm files

[ahsankhalid]

I have nearly 65 excel(xlsm) files all have the exact same structure. Only the data is different. I have a summary sheet in all of the files and would like to input summary sheets into Alteryx designer from all the files. 

Please can someone show me how to do it. 

[MarqueeCrew · Accepted solution]

@ahsankhalid ,

I've worked through the reading of the xlsm's and used a Directory Tool to find them. Then used a dynamic input to read them all.  I also added the filename so that I know where each record comes from.

Cheers,

Mark