You have hundreds of macros in this workbook are they all necessary? I looked at some of your basic formatting where you have some opportunity. The way a workbook is formatted will show professionalism and makes it less tempting for some Yahoo to go around unprotecting worksheets and inserting rows etc. What I mean is your red yellow and green boxes are not all aligned this can easily be fixed by holding ctrl and shift when dragging one of the colors. It will keep them perfectly aligned and duplicate the shapes. Also you have center formatting applied on some of your columns but the words are not all centered you should look at this.

as far as your Ref# that you are getting this will happen anytime you paste or move a formula that disturbes another formula in a workbook. So maybe you have another formula in your workbook that is being corrupted when you paste the data.

Lastly alot of your ideas on this workbook are great it looks like it has a great layout give us some specifics on what the workbook is suppose to do and maybe we can give you a hand to simplify all of the vba.

Thanks and good job.