I'm working on a production report. I have a large number of small excel sheets from all departments of the mine, and I want to pull information from them into my production report.
I have a column of file names (based on dates) like 38391.xls
Instead of typing...