Is there any way a tab (ie worksheet tab) can be linked to a particular cell.

So when the cell is updated, so is the tab name ??

 

You could try this bit of code.

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False 'stops change event repeating
'takes the value of cell A1 and renames the active sheet
ActiveWorkbook.ActiveSheet.Name = Cells(1, 1).Value
Application.EnableEvents = True
End Sub

HTH

Mark

 

Aaah, the joys of VB.

VB, I presumme ?