CRM Search Box & Display Results

Guys I'm looking for some help with a CRM system that I am building.

I have attached the template of the work so far....... please feel free to use it if you have contributed.

So as you can see when you open the Excel sheet there is a main page for a search capability. Basically I need it all interlinked.

When a colleague types in the search boxes I would like the results to be pulled from the separate sheets so its displayed within the main search sheet (Buttons are for editing existing details). You will see what I mean when you open it.

If you have any questions to ask or queries then please get in touch your help would be much appreciated

James

Your file is protected....