Building a search tool

Hello,

i need to build a search engine that can pull data from three separate spreadsheet (paperwork, C&Q, LDC) based on date parameters people can place in the box. i have no clue how to do this.
If any one can help, or point me in the write direction it would be appreciated.

helpfile1a.xlsx

i have attached a copy of the file if any one takes a look.

Thank you

Kind Regards

Chris