Creating List of 25 "Journal" Entries Depending on data entered

I have created a spreadsheet for property managers to input the rents they collect each month. Each building has a different amount of apartments, and sometimes people don't pay on time. I want to make it where EXACTLY 25 journal entries print on each page. For instance, on one tab, there would be the rent roll for the entire building...let's say it has 88 units. Let's say 81 people pay rent and the property manager enters the amounts paid for each unit. The 7 people that didn't pay are scattered throughout the unit numbers, for instance apartments 5,9,12,45,60,63, and 78. After the manager enters the information on the master rent roll, I would need some type of code that iterates down the list and then creates lists of 25 "journal" sheets ready to print. The journal sheets cannot have blank spaces where those units didn't pay. In the example above, four journal sheets would be created (perhaps on different tabs or on the same tab) that are ready to print. The first three journals would have 25 entries and the fourth journal would have 25 lines, however only 6 lines would have information (81 people paid minus 75 people on the first three journal sheets = 6 left for the fourth sheet).

I've attached the version I've created. If you hit print preview, it shows how it should look...25 lines. On the "Rent Journal" tab, the print section is B1-O33.

The summary of the main issue I'm dealing with is when somebody doesn't pay, I don't want them to show up on the journal that's printed. Contrarily, I also don't want to manually type in the tenant information each month based on who has paid and who has not paid.

Any suggestions are greatly appreciated!!!!

Thanks for the quick reply and nice photo!

The column headings will stay the same as well as the data. You'll notice some of the data (in the print area) is the result of formulas from areas outside the print area.

I do not need any journal for those who have not paid. In fact, this is simply used as a way to print and no electronic backup will be created with this.

To give you a background, our on-site managers collect rent each month. This will be the software where they "code" the charges for the money they collect. For instance, if somebody pays a $2,000 check, the manager may code $1,000 as rent and $1,000 as security deposit. The software will do the math and make sure it balances. Once they are done inputting whatever money they have collected, they just need to print out a journal with exactly 25 lines to bring into the office along with their rents. If they have more than 25 payments, they will obviously have multiple journal sheets they bring with them. Once they come to the office, our accountants use the journal printouts to enter it into our actual Yardi accounting software.

So, in summary, this is just a way to create a uniform way for the managers to show our accountants what money they are bringing in. Right now, with 100 different property managers all using different spreadsheets, our accountants in the office are going crazy because it's taking way too long to enter the rents into the accounting software.

Thanks!!!!!!!

I've attached a version with some data. You'll notice the rent roll section has 29 tenants, however since 25 of them paid, the journal page only displays the ones who paid.