Tried to Build a Macro, but couldn't make it repeat for multiple rows.

I have built several spreadsheets over the years, but this is my first time to try my hand at macros. My current workbook has 17 sheets almost all providing data of some kind to another sheet. Sheet 1 calculates the variable price of parts based on size & number of operations. The inputted data is moved to 6 different sheet and back to sheet 1 with 6 sets of pricing.
Sheet 17 is a list of parts with the different sizes and operations listed. There are 1200 different parts. Currently I copy 4 cells of data form one row on sheet 17 and paste it into sheet 1; then I copy the values generated on sheet 1 and paste special the data on the row where I originally copied the data from on sheet 17.
I am trying to automate this. Sometimes I fail in pasting special and just paste; that just results in incorrect pricing. I created a macro recording, but it only does the one row. I need some guidance.
Thanks in advance!

I have attached a sample file