Is there a way to dynamically continue numbering between tables?

Hello
I am trying to have a consistent numbering between tables since I am trying to have a consistent numbering of a general Operation ID that is present on all the tables (that number is like a transaction ID but its present on different tables because there are different types of transactions but it is important to know the overall ID of that transaction, regardless the number sequence in the given table)
I already research different forms of numbering like this one

trumpexcel.com/number-rows-in-excel/

But all of them are using only one table, not a sequential dynamic one like what I am trying to do.
So. What I am trying to do is going from this (where there is numbering sequence for a unique table)

i.redd.it/3n8ygarbhcb31.jpg

To this (where there is numbering sequence between tables; I added color references to represent the "jumps" of numbering between columns)

i.redd.it/9tq45h4hhcb31.jpg

I am trying to automate this process instead doing it manually. So ideally it would like store the current Operation ID (maybe a VBS variable or simply a formula) and whenever I enter a new data on a given table it would continue the previous Operation ID
Any suggestions or ideas are welcome
Thanks in advance!