Save data from one workbook to another by pressing a command button

Good morning,
I've attached two workbooks Request2stock and Need to stock 2198.
Here is what I need to happen when a command button on the Request2stock workbook is pressed.
1. Decipher whether the part being requested is electrical or mechanical, Maybe a checkbox could be added to the worksheet.
2. On the Need to stock 2198 this data from the Request2stock worksheet will be added to a new row under mechanical or electrical and all data will be populated under the corresponding cells, (Description, PartNo and Manufacturer) All other data will be filled in manually by a user.

I hope someone out there can help with my request.