Is this a peculiarity in open office? (seriously)

I own a small business. Each of my customers is assigned a sheet for billing purposes in Open Office. I have 74 customers and 74 sheets. Each sheet is labeled with the customer’s last name.

Frequently (enough to make me insane) the program transfers the heading I’ve just worked on to the following sheet. For instance, Sheet 1 header will be Ms. Prissy Abbot, 1234 Hastings, Podunk Iowa. Sheet 2 header will be Mr. Ralph Rowdy, 6969 Lake DooDoo Drive, Brickshit Kansas. The header on sheet 3 reads Ms Sally Sunshine 87 Gobroken Hwy, Upper Shitsville Ca.

All headers are supposed to remain on the sheet that they were entered. Each month I open the file to reveal all of my customers on separate sheets as they should be. It is my missive to add data to each sheet leaving the header static. Prissy has paid money making her balance 0. She has also purchased more items from me that will be entered on another line. She can look at all her purchases and payments as well as her current balance. All is well and good in the land of nod.

But wait! After the data is recorded on Ralph Rowdy’s statement, we come to find out that the header on Ralph’s sheet is that of Prissy. That is, Ralph’s prior data is intact as well as the new Ralph data I’ve entered. Its just the header that’s off. The sheet belonging to Sally Sunshine in Upper Shitsville may or may not have Ralph’s header. It will not have Prissy’s header.

Prissy doesn’t want Ralph’s bill which is higher than her own and I don’t want her to know that Ralph shops at my store. And anyway, why would I want to send Prissy Ralph’s bill?

Therefore, every time (or some of the time or sometimes) I click on a different sheet, I have to check the header and reenter the name and address of that customer. This process hinders my billing speed.

Question: Has anyone ever heard of this? If so, how do I get it to stop doing this? What am I doing that I shouldn’t be doing that causes this to occur?

I thank all of you good and giving individuals out there who are willing to take the time to answer this question. But please, resist the temptation to tell me I need to use another accounting program as it has nothing whatsoever to do with the question I’m asking.

In gratitude,

Carol