Selected Answer
Squishy
The "search panel" used in Don's tutorial Fast Search Multiple Workbooks in Excel with a File Picker - VBA Macros (where the files are) is created using the techniques explained in another of his tutorials here: Idiot-Proof Forms in Excel - Part 1 - Formatting (and I suggest you look at the other tutorials in that series).
To search on a single value, we can eliminate the Field cell on the worksheet and within the code we can replace this portion of the code:
'Get user input
searchValue = dashboard.Range("C4").Value
fieldValue = dashboard.Range("E4").Value
'Clear Dashboard
'Call Clear_Data()
'Figure out by which field we will search.
If (fieldValue = "ID") Then
searchField = 1
ElseIf (fieldValue = "Name") Then
searchField = 2
End
with the simplified
'Get user input
searchValue = dashboard.Range("C4").Value
'Clear Dashboard
'Call Clear_Data()
'Specify which field we will search.
searchField = 2
where I've picked data column 2 -Name- to fit in with the test files on the Tutorial). In your case you'll design your form to suit your data (and have Signal named as your search criteria on the worksheet).
I've attached a revised tutorial .xlsm file to show that (including the reduced code above) plus the original test data files from the tutorial.
Hope this helps.