I'm not certain what category this falls into, but here is a summary of what I am trying to do:

I get sales info emailed to me daily in .csv format. I keep a separate workbook where I incorporate info from that sales report to track sales on each day and to keep the relevant info in one place. However, I'm tired to opening the file each day to update all the info. Is there a way to do this automatically, or to be able to update once a week or so with a command? It takes far too much time to open multiple files, get info from the same cells within each file, update my master workbook, and check for accuracy. I'm hoping there is a way to automate this.

I have office 2007, if that helps.

Any advice will help. Thanks in advance!