I’ve been trying to add an automatic page number but it only appears on the first page where the cursor is set when I choose insert page count. How can I do this and make it appear on the middle and bottom of each page?
You need to insert a footer, then put the page number in the footer. Then it will appear on each page; you can align it in the footer to where you want it - left, centre or right.
Page Numbers - LibreOffice Help and for more information scroll down for a link to page numbers in footers
If this answer helped you, please accept it by clicking the check mark to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.