Attempting to make my homemade inspections tracker easier to use

Hello,
I currently conduct around 50 inspections a month and each is resulted as a pass or fail. If it fails, I have to input what category fail it is and the reference that tells them they are wrong. I have a product that I made and it works, however it is difficult to add and delete the extra rows without having to check all my formulas and fix my colors. I am always copying and inserting copied rows if I need more space. Than I'm forced to merge the other cells to make it look decent and wrap the text. If the inspection results in multiple areas of failure, I have to add an extra row for another major or minor finding. if anyone has any advice it would be much appreciated. I also leave this job in the near future and I would like this to be user friendly so my turnover can use it even if he's horrible with excel. Thank you for the help. Attached is a sheet with a few of my inspections and the data I use to track it. Thank you for the help. I'm also not sure if my attachment is here or not. Please let me know if it is not.