VBA - Search For Value Across Multiple Worksheets

[paulked]

You can't have line spaces after If!!!

For Each sh In ThisWorkbook.Worksheets        'Don't include PO Accrual Data
        If Sh.Name <> "Instructions" And _
       Sh.Name <> "Accrual & PO Data" And _
       Sh.Name <> "Tab Name List" And _
       Sh.Name <> "Subtotal Macro Button" And _
       Sh.Name <> "Input Date" And _
       Sh.Name <> "Summary FY19 F1(5)" And _
       Sh.Name <> "Summary FY19 F1(4)" And _
       Sh.Name <> "Summary FY19 F1(3)" And _
       Sh.Name <> "Summary FY19 F1(2)" And _
       Sh.Name <> "Summary FY19 F1" And _
       Sh.Name <> "EP Local" And _
       Sh.Name <> "Driver Definitions" And _
       Sh.Name <> "EP Global" Then

It compiled but I haven't tested it because the sheet numbers have changed, that code refers to Sheet2 which doesn't exist in this workbook.