OK, so I have this maco to name a tab to the contents of cell A1, but I have
no idea what to do with the macro...

Sub name_um()
For Each ws In Worksheets
ws.Name = ws.Range("A1").Value
Next
End Sub

....and can I save the macro so that I can use it in other workbooks?