#REF in my formulas when I insert a new line.

I've got a database which takes input from a form. Each time I press "Submit" a new row is inserted(not added)in the database, all duplicate names are removed and the list is resorted A->Z.(There is a macro to do this)

The problem is I must draw graphs to show the current state in the Database and I have constructed formulas to extract this data, but each time I submit a new name all my formulas return a #REF value.I have tried to make range in my formulas referenced by putting in the $ but they still change. I am not permitted to change the "Submit" macro.

An example of one of my formulas is : =COUNTIF(Concise_View!$H$11:$H$350,$E$3)

Any help would be greatly appreciated