Please read the forum rules again. #2 Should be of interest to you.
What are b (For i = 4 To b) and c (For i = 4 To c)?
Are these very large, lots of data, sheets?
If I understand your requirements right, does this work?
Sub Maybe()
Dim shArr, i As Long, j As Long, sh3 As Worksheet
shArr = Array("SIE 120V Panels", "SIE 120V Breakers")
Set sh3 = Worksheets("BOM")
For i = LBound(shArr) To UBound(shArr)
With Sheets(shArr(i))
For j = 4 To .Cells(.Rows.Count, 1).End(xlUp).Row
If IsNumeric(.Cells(j, 1)) Then .Cells(j, 1).EntireRow.Copy sh3.Cells(sh3.Rows.Count, 1).End(xlUp).Offset(1)
Next j
End With
Next i
End Sub
Bookmarks