title: Excel VBA Multiple Sheet Search using Data from one Column
body: <p>I am trying to search for values listed in a column from multiple sheets in my excel workbook. If excel finds a match I would like it to return sheet names of the tabs that had the value.</p>
  <p>Here is what i have done so far. I decided to start off by using one keyword to search multiple tabs, copy and paste the sheet name. The code below only paste the first resulting sheet name when there are other sheets containing the same keyword. I would like to know how i can pull the other sheet names that contain the same keyword.</p>
  <p>I would also like to know how i can set up the keyword to use information in Column A of the Field List.</p>
  <pre><code>Sub FinalAppendVar()
   Dim ws As Worksheet
   Dim arr() As String
   Keyword = &quot;adj_veh_smart_tech_disc&quot;
   Totalsheets = Worksheets.Count
  
   For i = 1 To Totalsheets
    If Worksheets(i).Name &lt;&gt; &quot;Main&quot; Or InStr(1, Worksheets(i).Name, &quot; Checks&quot;) Or Worksheets(i).Name 
     &lt;&gt;_ &quot;Field Lists&quot; Then
     lastrow = Worksheets(i).Cells(Rows.Count, 4).End(xlUp).Row
    For j = 2 To lastrow
       If Worksheets(i).Cells(1, 3).Value = Keyword Then
         Worksheets(&quot;Field Lists&quot;).Activate
         lastrow = Worksheets(&quot;Field Lists&quot;).Cells(Rows.Count, 4).End(xlUp).Row
         Worksheets(&quot;Field Lists&quot;).Cells(lastrow + 1, 5).Value = Worksheets(i).Name
         Worksheets(&quot;Field Lists&quot;).Cells(lastrow + 2, 5).Value = Worksheets(i).Name
       End If
  
       Next
  
     End If
    Next
  End Sub 
  </code></pre>