I’ve made a spreadsheet using multiple blocks which I call an individual record. My sheet has 100 records per sheet. My counter in each record counts up or down with adds or subtracts from the records. But when a sheet is full and I move to the next page how do I code to the last cell of the previous page so that the count continues?
I am still having a problem with linking my record count page to page. If my 1st page is named Sheet1 then per theory this reference to sheet1’s last cell which is ( BE389 ) should be =Sheet1.BE389+1. This is not working unless I change the +1 to 101 then it works but it is ignoring the 1st sheet in effect.
Update … I was doing some cosmetic reformatting of my records, during this the last record cell ( which is key ) was removed then re-pasted… and NOW this =Sheet1.BE389+1 now works. I’m not sure why this didn’t work before but just happy to move on to whatever the next problem will be.
I hope I understood your request correctly.
For example, in Table1, the last record counter in A100 is 100. Then, in Table2, you write in A1, “= Table1.A100 + 1” (without the quotation marks).
I hope it helps you.
If my answer has solved your problem, please click on the checkmark in the circle 
to the left of the answer and click on the arrow ^ for upvote. This will tell the community that the question has been answered correctly.
With me Windows 10 Home; Version 1909; 64-Bit | LibreOffice, Version: 6.3.3.2 (x64).
After an extreme amount of testing I’ve gotten much of my project to work. I have identified some work principles that I have made into rules for myself.
(1)-- WORK ON COPIES!!
(2)-- Create your spreadsheet with enough “space” around it for adjustments as you develop your project. Meaning start at C10 or another such random number easy to remember and identify that “weird” things are not warping your design!!
(3)-- When you design your “FORM” put the start at your “C10” or what you choose then record the end cell which in my case is “BE394”. This makes an easy check on the “WARP” problem. This also makes a check on your counters … I have cross checks every 5 records and on every row there is an indicator of your location. I’ve done this because when zoomed in close for examination you will loose your way without these signposts. It is such a pain to zoom in and out constantly!!
(4)-- Lastly I cannot stress this too much “SAVE OFTEN”!!!