Have a look at this blog post
To the script below you could add the Trace function to display variable to the screen & log.
For each vFile in FileList('C:\Users\aby\Desktop\*wildcard.xlsx')
Load Col2+Col3 as Total,
Filebasename() as Source
(ooxml, embedded labels, table is Sheet1);