[COLOR=blue]Private Sub[/COLOR] CommandButton1_Click()
Application.ScreenUpdating = [COLOR=blue]False[/COLOR]
[COLOR=blue]For[/COLOR] i = 4 [COLOR=blue]To[/COLOR] Cells(Rows.Count, "A").End(xlUp).Row
Var = Cells(i, 1).Value
[COLOR=blue]For Each[/COLOR] f [COLOR=blue]In[/COLOR] Worksheets
[COLOR=blue]If[/COLOR] f.Name = Var [COLOR=blue]Then[/COLOR] Present = [COLOR=blue]True[/COLOR]
[COLOR=blue]Next[/COLOR] f
[COLOR=blue]If[/COLOR] Present = [COLOR=blue]False Then[/COLOR]
Sheets("Model").Copy After:=Sheets(Sheets.Count)
[COLOR=blue]With[/COLOR] Sheets(Sheets.Count)
.Name = Cells(i, 1)
.Cells(1, 1) = Cells(i, 1)
.Cells(1, 2) = Cells(i, 2)
.Cells(4, 2) = Cells(i, 1)
.Cells(4, 4) = Cells(i, 2)
.Cells(5, 2) = Cells(i, 3)
.Cells(6, 2) = Cells(i, 4)
.Cells(6, 3) = Cells(i, 5)
.Cells(7, 3) = Cells(i, 6)
.Cells(8, 3) = Cells(i, 7)
.Cells(12, 3) = Cells(i, 8)
[COLOR=blue]End With[/COLOR]
[COLOR=blue]End If[/COLOR]
[COLOR=blue]Next[/COLOR] i
Application.ScreenUpdating = [COLOR=blue]True[/COLOR]
[COLOR=blue]End Sub[/COLOR]