User Form Transferring Data into Separate file

Hello, at work we have a shared spreadsheet which is updated by many different people.
Lots of people use this spreadsheet from around the site to enter new information. The information it holds is the movements of ISOs around site; where they are, what they have in them and how much. This is very fluid and can change daily - plant managers and planners need to know where our bulk material is and much we have stored in the ISOs

The spreadsheet is setup to transfer current data from the user form into the master data tab and then copy old information into an archive sheet within the same work book. What I would like to do is separate out the form and the datasheets - both master and archive.

Below is the code behind user form - what I need to know is how do I set it up to make it copy the same pieces of information but onto a different workbook saved elsewhere? In my head we would ideally have one spreadsheet that is the user form that the end users use to update records and then another spreadsheet that is used to keep the master data but also the archived older data.

The code as it is written now is below - I really appreciate anyone's help

Please Login or Register  to view this content.