Data from one file into running totals in another?

Hi folks,

I have two spreadsheet files. Both contain figures.

One is updated daily and cleared daily.

One is updated daily and maintained for a five week priod then archived.

I am trying to identify if there is a way to automate as much as possible, the process of the figures in file 1, transferring into file 2 and being added into the running totals?

Any help greatly appreciated!