Excel 2007 VBA

I am trying to make the tab name change to a particular cell value automatically when the cell text is changed.

I am not sure of how to make this happen.

Thoughts?