Snapshot of a cell value

Options

Is there anyway to record what value is in one cell on one sheet into another cell on another sheet at a particular time and date.

I am trying to streamline my job and every afternoon I have to record values from a master sheet into a financials sheet, if I could enter a formula into the financials cell to pull the value it needs from a particular cell at a specific time on a specific date then I could skip this one job everyday.

Any ideas?

Answers