Create a summary report of ordered items from multiple worksheets help

I have employee uniform order worksheets (around 20), see picture. The order form has drop down menus that pull from a product list (pic attached). Once the item is selected the corresponding item # and price is autopopulated. The item number is then concatenated with a 3 letter color code after the item color is selected. I manually enter a quantity to calculate a total price.

What I need to do is create a summary worksheet that pulls all of the items to be ordered, (description,item #, qty and total price for each product) from the employee worksheets and compiles into one summary report. What is the easiest (best) way to do this?EMPLOYEE WKSHT.pngPRODUCT LOOKUP.pngSUMMARY.png

How to:

Attach a sample workbook. (Not a picture!)
Make sure there is just enough data to demonstrate your need. Include a BEFORE (original) sheet and an AFTER (required output) sheet in the workbook if needed to show the process you're trying to complete or automate.
Make sure your desired results are shown, mock them up manually if necessary. Remember, it should reflect original structure of your data.
Remember to desensitize the data.
Note:

• Please do not attach password protected workbooks/worksheets
• Please do not attach file(s) from exterior servers
• Please do not attach file(s) with enabled any Workbook Open/Autorun macros!

20 rows of data is enough (probably)

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
If link is not from FORUM server you have to wait until someone will want to watch the file from an external server.

Sample workbook.