Hi barnesy1977

Are the files attached the SAME structure as your ACTUAL files? I'm going to assume they are for the moment but, if they're not, please let me know ASAP.
Regarding this
The 2nd worksheet would be a summary of Daily Sales from the previous day (I would paste the sales into this worksheet each day, as the filename on the downloaded version would change every day so could be difficult.)
This too can probably be automated but we'll look at that later.