Hello all,

First time poster here and VERY new to VBA. I am requiring a macro that searches roughly 60 (yes 60 lol) worksheets in a workbook that returns the text from the correct fields of each worksheet into a summary sheet.
For example:

the # 101 may be in some, none, or all of the worksheets. The description in the cell beside it would be the reason it is there (ex 101 is a truck that broke down, reason being the diff pressure was high). I need a macro that when a truck # is picked from a drop down box, someone can press a search button, the macro then searches the worksheets for that truck #, and for each instance it finds that truck #, it then copies and puts the reason for breaking down into a summary.

I realize I may be vague with some of this so forgive me. Thank you in advance for any help that may be provided.