Automatic periodic collection and organisation of data from a spreadsheet

[ben_walker5]

Hi, I'm trying to create a spreadsheet that will collect data from one master spreadsheet that is updated manually every day (to indicate total items on order). I wish to automatically import this data each day and save it under a column noting the day on which it was imported. Ideally this would happen automatically as soon as the file has been updated but it could be done periodically at a certain time each day. Any help would be much appreciated! I can provide further information if required.