Delete #REF rows and move rows up if it's on the first line

Hello,

I have a basketball season data workbook that I am working on and I am looking on the main page to remove rows that contain a #REF! value in the cell. However, I am looking for it to do that if a #REF! cell appears on the same row and the name of the player that I would like to clear the cell and move up the first available non-#REF! row next to the players name.

I have attached my workbook and an example of what I am trying to do is look at Matt Wenstrom on the 1993-94 Stats worksheet.

If someone can help me out with this so I don't have to manually go through and remove that would be great. Thanks in advance for your help.