I have the following macro:
Sub Rename_Sheet()

ActiveSheet.Name = ActiveSheet.Range("M2")
End Sub
This macro will change the name of the sheet into what has been filled in
the cell reference.
Does anyone know how this can be done / run automatic when the Cell is
changed / filled in?

Thanks