Private Sub Workbook_BeforeClose(Cancel As Boolean)
Dim I As Long, J As Long
For I = 1 To 3
Sheets(I + 2).Name = Sheets("Table").[A1].Offset(I - 1)
Next I
For I = 2 To 3
For J = 1 To 3
Sheets(I).DrawingObjects(J).Caption = Sheets("Table").[A1].Offset(J - 1)
Next J
Next I
ThisWorkbook.Save
End Sub