Sales Management

I need to develop a connected excel sheets to be used by sales employee to feed information and export a formal quotation. The completed quotations shall be saved in excel format in a specific folder with quotation number as file name. Also, a PDF copy shall be saved to be shared with customer. At the same time all these information shall be logged in a different excel sheet. Sales engineer should fill the information in a friendly interface with drop down lists with different classifications. The excel sheets formatting and relationships shall be locked. A sub-routine shall assign a unique quotation number for every quotation. the sales engineers are not working within same network, however, they are working from different areas with different network. So, the quotation number shall be unique and consistence to every sales engineer. On the other hand, the sales manager should be able to pull the information and combine them in one master file. Then, export reports and statistics based on date, area, sales engineer, industry, ...etc. The report shall be exported in defined format.