Regarding the errors, that is understandable. I am entirely self-taught when it comes to VBA, so while I have a fairly decent grasp of some concepts, there are definitely large holes in my knowledge.
As for 5 and 6, let me explain a little more what I am trying to do.

Basically, information is submitted each week. I would like to automate the process. Each category (the predefined names) has a varying number of rows each week. However, sometimes information does not fit into the predefined categories, so the people that submit the information add a category (category titles are the only things in bold in the document). I want to be able to tell if a category is added, and here is were things get a little complicated.

If it is after all the predefined categories, then it is safe to copy and paste everything below the category (as I will not be duplicating data). However, if they inserted in between the predefined categories, selecting everything after will duplicate data. To avoid this, I either want to a) copy and paste all the data in between the new and predefined categories, or if that is not possible b) tell the user that they need to move the data manually.