The title's probably confusing so I'll try and explain. I've created a worksheet that is connected to some trading software. From that software I'm able to link a countdown clock for a particular market into a cell in Excel, this countdown clock signifies the time remaining until the kick off of a football match and counts down until 00:00:00 (which is Kick off). Using this clock would it be possible at say 10 minute intervals for Excel to paste a range of data from one set of cells to another?

For example I have the countdown clock in B1. The data I want to copy is in the range AA2:AC21. The destination cell to paste into is V2. The data in AA2:AC21 is updating constantly in real time and regularly changing, the paste part needs to just be the static values if that makes sense.

Not sure if this is possible but thought i'd check it out anyway. Thanks in advance for any advice.