Change Quotation and sales order creation

Dear All,

I have some requirements from my company that I have to adopt to SAP. My company is a reseller of IT materials.

Our sales people are using an excel file to make the quotation to a customer. This excel file contains a couple of sheets (one for each manufacturer. example IBM, HP, Microsoft etc). Is there any way to make my quotation and sales order look like this?

Also since all the data for the initial creation of the quotation are stored in these files, is there any way to automate the creation of the quotation by transfering all the data from the excel file to the SAP ERP?