Hi,

I'm trying to do several things with the goal of automating some reporting, and am not sure what the right tools to use are, so maybe you folks can provide some clarity for me. I'm trying my best and have been trying many different tools, so any help is very appreciated!

Basically, I have a directory full of daily Excel files that I need to open, and merge into a larger sheet.Based on the file namesI need to add...