Why does an extended formula change over time?

Question

excel

There is a Google table, logs are constantly loaded into one of the sheets. On the second sheet on 10,000 lines, I add a formula for copying data from the previous sheet in the format = 'logs'! A1 and so on for each line for 10,000 lines. But 15 minutes pass and the formula starts to go astray and on the 100th line the formula turns into ='logs'!A115 instead of ='losg'!A100, the lines seem to be deleted, in connection with this, data is lost. What could be the problem? I can’t provide screenshots, because. there corporate information