spread sheet to requisition form value copy??

Hi all.
I have been away from programming for years and have slipped into the newbe stage again (don’t think I ever left).
I am in need of some help with two work sheets. One is a set requisition form and the other is a changing spread sheet. I will use a form to fill out top half of the req. I need something that will auto-fill lower part. Col. B is quantity and Col C is part number.
Spread sheet Col. A is part number Col. B is quantity Col. C is manufacture.

I need to fill req. form based on Col. C and as manufacture changes, save form and open new template until all manufactures have req. forms.

Can this be done with the item columns not matching in the two spread sheets?

Thanks for any help you can give.