Developing Search Engine to search several Excel sheets

Good Morning,
I am currently in the process of setting a system up at work where i need to search several closed excel worksheets for relevant information

I have read on a post on another website that someone has done this in the form of a Userform where the user enters a First Name/Surname and selects a command which searches the excel forms within a folder at a set location and then opens and indicates the information that was requested.

I am fairly new to Excel but this is exactley what i am wanting to do Is there anyone out there who would like to try and assist me please?

I would want the userform to do searches of three different sets of information.

1 Search would be: Surname/First Name

2nd Search would be: Address

3rd Search would be VRM (Vehicle Registration Mark)

ANy assistance with this would be really appreciated