create automatic summary worksheet for Po order form

Hello

My company is using excel order forms (received by fax, email,.. )

They are really inefficient and right now our customer service has to retype them manually and they don't want to have a online system...

So I am trying to automate the import of those excel spreadsheets to sqlserver, then send it to Db/2

As you can see on the spreadsheet attached, I was thinking to create summary page for any values entered in the "Data Entry" Worksheet, so it will be easier to export them to sql later on.

something like
item / size / qty / price / discount

I can create those manually, but those order forms are changing many times.

So if anybody has any input how to automate this process or if there is a better way to achieve it, I will really appreciate it.

Thank you very much for your time
yohan