Well we don't need an array, just a loop.
Where is this list located?
Let's say it's on Sheet1 and starts in A2.
Dim wsForm As Worksheet
Dim strName As Worksheet
For I = 2 To Worksheets("Sheet1").Range("A" &Rows.Count).End(xlUp).Row
strName = Worksheets("Sheet1").Range("A" & I).Value
Set wsForm = Worksheets(strName) ' worksheet to be formatted
Select Case Worksheets("Sheet1").Range("B" & I).Value
Case 1
' Apply type 1 formatting to worksheet wsForm
Case 2
' Apply type 2 formatting to worksheet wsForm
Case
' Apply type 3 formatting to worksheet wsForm
Case 4
' Apply type 4 formatting to worksheet wsForm
End Select
Next I
Bookmarks