Auto fill last km of cars

Greet the forum. I believe you are all well. At below workbook i need an help. The red numbers, in last two sheets can be filling automatically? If you see the red numbers and the second sheet you will figure out what i need.
Thanks in advance.

Thanks to JeteMc, the first step completed, can anyone else help me with the 3rd sheet please?

This solution is only partial in that it only fills in some of the red values, quarters 1 - 4, on the last sheet. It looks like the last value on that sheet, km Now, is supposed to be the same as the fourth quarter and if so a simple =I9 will work, however as today is in the 2nd quarter I was not sure. The array formula* that takes the final km reading for the quarter from the LAST KM OF CARS sheet is:

Please Login or Register  to view this content.

* Array formulas are confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. I am attaching a copy of your file with the formula applied.
Let me know if you have any questions.

Thanks a lot JeteMc, i will try it and i let you know for it.

JeteMc it works fine a big big big thanks for your help!

Deleted by JeteMc

No its not completed because i need a little help in sheet 3!

If I understand the requirements for the 4 QUARTER OF YEAR sheet you want the columns to fill from the first row of the CAR NUMBERS sheet 8, 1, 15 ... 97 then start with the second row, 2...85 then the third and so on. Is that correct?

No.. I have use only two cars but i have made it more complicated, haha. For any cars there in the second sheet, i want in the first quarter to listed by type. So, first the cars of the list A, after of list B, after of list C and so on. This for all quarters.