I am currently updating a series of Excel sheets which change daily.
I set it up so that it has references to the source file and once I
replace the source file with the new data, then the sheets get
updated. I have been asked to keep the data from previous week "as
is" and just append the new data each and every day. I have to copy
and paste the information to the sheet, but because the cells are not
continous, I spend hours in this process. Do any of you have any idea
as to how I could possibly add some sort of automation to this
process?

Thank you,
Mildred