Using VBA to Format sheet layouts for printing

Hi,
So I am back to using Excel after 6 years and after appreciating the software the first thing I notice is the massive abuse of excel functionality by my colleagues (including me).
I am using excel to print different documents like bill of materials and other similar lists. The excel sheets undergo editing regularly and that is where my OCD comes into play. Everyone takes the liberty of moving things. So when a document is ready for print it might not look like its previous versions. I want to standardize the final printing layout. Somethings that I would like to do is:
to have fixed row and column heights
fixed number of rows per page
borders of same width around the pages
rows to repeat at the top and bottom of the pages with correct page numbers added (maybe this can be done by making a dynamic header and footer)
fixing margins and scaling etc.

My idea is once the data inside the lists is ready, a click can format the sheets to the standard format for that particular document. Being not an expert on Excel and VBA I am not sure if this is possible. So my question is, whether this is possible and if yes can someone nudge me in the right direction?

Searching Google didn't help me much except suggesting a few paid plugins; maybe the keywords I used in searching aren't correct. I would appreciate any kind of help as my OCD is killing me here.

Thanks for the reply, that is a good idea.
I was also looking at other options. One that I like is to use templates so there does not need to be any dynamic code. I made a default template with a 100 pages (I inserted the rows at the top and bottom manually with the document meta data as

#project_no

or

page number 1 of #total_pages

. These should be easy to edit using the find and replace tool. Now I need to check on how to populate the template. The challenge would be to import the rows from the original sheet but divide them into a set of 30 rows so they can be put in the template pages in the correct place. Will see how that goes.