Delete row and move information up for current month and each month after

I have a spreadsheet where I have information in each month. When I click the cell with the name and hit the delete button it deletes the name in that month, moves everything up, but not for the months after. the months after it gives me a #ref error. Is there a way to delete information in one month excel will automatically delete the inforimation in that month and the months after it moving the information up so there is not a blank row? see attached.