A beast of a program has been created and so many of you have contributed knowledge and insights and I am now WAY in over my head - perhaps you fine excel masters can help me be a hero

One sheet is named Dash Board - on that sheet are customer fields and specific information from contact phone number measurements etc - the current process is to open the work book add the customer information and "save as" that property name - saved to a network in a file that holds all of these information filled in with all of that particular customers info.
On the network sits a copy of the blank workbook in all of its glory - I thought hey what if we could enter a customer name or a specific work site on the blank workbook and it pulls all of that particular customers information into the required fields
These customers have very specific data entered into them across multiple sheets which are populated by entering the measured data on the "Dash Board Sheet"
So i figured there were 2 ways to do this on the dashboard sheet type in information into say the " Site" box or in the "Company" box or even a search box - it searches through the customer files on the network (which is its own file on the network with sub folders IE site name (which are just filled in copies of the workbook)) and when it finds that customer open that excel file separately (which would work fine and may be the better way to)
My vision was that doing the above action (entering the site field or company field or what have you - a pop up box with all files related to the information of the name or company associated with what you typed in - you select one of the names or sites in the pop up box and it would fill in all of the dashboard customer and site information along with the measurements and previous quotes associated with that file
Either way with tons of new customers - going to the network - then to the customer folder and then finding that customer takes day and is not efficient
I know Im asking way too much and I have watched countless videos and read tons of how to make a search engine in excel - but i have failed miserably in making any of these work for this workbook
I have attached an unlocked version of the work book and if you come up with a solution please be gentle in it's explanation because I am still dawning the Noob championship title
Please know that I am forever grateful and hold all of you in the highest regards and with the utmost respect
forever you pupil
mdhancockga @ gmail comcan this be done 1.zip

i had to remove some files to be able to upload the workbook