In Excel selecting a sheet from drop down menu, searching specified sheet for partial matches, returning a hyperlink to the document

Hello I need some help creating an excel function that acts as a sort of search bar.

I would like the function to search a column of keywords and return any records with partial matches.

The workbook contains multiple sheets (ex. SearchForm, Car, Home, Personal) that are referenced from a drop down box in cell A2 on SearchForm. I want to return the top 10 records into cells on SearchForm.

SearchForm has 3 parts, a dropdown (A2) that contains sheet names, A5 which allows users to enter in a keyword, and an area A10:B20 that is allocated for the 2 returned rows.

The user selects a sheet from the A2 drop down, and enters in a search word in A5. I want the formula to then search the correct sheet (given by A2) for any partial matches to the keywords which are in column 1. I would like to return best matches from column 2 (Name of the document) in A10:A20 and column3 (which contains a hyperlink to the document) in B10:B20

This is the formula I am using but to no avail as it keeps returning errors. =INDEX("'"&A2&"'!$A:$C",SMALL(IF("'"&A2&"'!$A:$A"=""&$A$5&"",ROW('"'"&A2&"'!$A:$A")),ROW(1:1))+0, 2)

I would also like to eventually allow users to enter more than one keyword and have the formula perform its search function but as of right now I’d like to get this smaller task out of the way. Any help would be appreciated or suggestions of an easier method would be appreciated as well!

Thank you!