Automatically copy paste data at certain interval

Hello Everyone,
I already have data in columns A2:C376, header in first row. This is my table. I am getting fresh new data every minute from my other office in D2:F2 between 9.20 am to 3.30 pm. Now I want a macro that automatically run every minute and run only between 9.20 am to 3.30 pm. Insert new 3 cells at A2:C2. The old A2:C2 cells will move to A3:C3. At the same time delete last row no. 376. Than copy and paste new data from D2:F2 in newly inserted cells. This process continues between 9.20 am to 3.30 pm at every one minute interval.
Thanks

Hi Kaper
Thank you for your help
We have office software through which I can link my workbook

Many Thanks Kaper,
I will see the result in couple of days.

Regards.

Hi Kaper,

Sorry for the delayed response. Many thanks for helping me out. This code is working absolutely fine.

Regards

Glad to hear so.
As the solution works, it would be a good idea to mark thread as Solved.
Above your first post you will find Thread Tools to do it.

It would be lovely if you could also "add me some reputation" by clicking a small star icon in lowerleft corner of my post(s) and then confirm in pop-up message (note that some browsers block this pop-up).

Best regards,

Kaper