Fix errors on a macro based excel workbook

I have an existing spreadsheet but there are errors that appear when entering data and some of the information isn't duplicating to another sheet in the workbook as it should.