Configure Excel to move data from one page to subsequent pages at a specific time interval

I am populating Excel from a server via KEPDIRECT. At a specified time interval, I would like to move the data either over or down in the file and populate the data into subsequent cells over either a period of time or up to a specific file size. Once that criteria is met, I would like to auto save the file. I need to store this data to be distributed to co-workers, so I don't want to save over the daily files. I would like to have it save based on the days date, if possible, in order to have an archive of process data to refer to. Are these things possible and how can I do it? I have, up until now, only used the basic features of Excel. However, the storage of historical data has recently become necessary. Any help in accomplishing this would be greatly appreciated. Thanks.

I have figured out the time interval and I have figured out a single data transfer from A1 to G1. How can I tell the program to copy and paste in increments. For instance, in the first transfer copy starting at A1 and paste to G1, but in subsequent actions copy starting at A1 and increment over "x" number of columns to paste? So the second paste would be at M1 and the third paste would be at S1 and so on. I am still searching and studying, but any help is appreciated. Thank you.

Thank you very much. The program did exactly what I asked of it. I am now trying to learn how to modify what you provided to transfer a group of cells (A1 to C6) in the same manner. I'm hoping that I can add a range statement or something simple to make the modification. I am trying to teach myself and I greatly appreciate your help. I am a PLC technician and the need for this type of Data Storage has never before been necessary. Thank You!