Just to be clear, there really isn't a business "form".
what you have is a spreadsheet, that "represents" (or simulates) a form.
In excel, the word "form" carries special meaning.

Just make sure you don't "bounce" back and forth
between the workbooks. It wastes a HUGE amount of time.
Do the second (and third, etc) workbooks already exist?
In that case, yes.. open  the second file, but you don't really have
to "move back" to the first file. In my previous example, simply
cycle through the:

sheets(thissheet).cell(1,1) =
workbook(Masterfile).sheets(mastersheet).cells(1,1)

type of scenario.
When you exit and save, you'll be back at the first book.
Of course, if you only have a couple of files, then the total cycle time isn't a
burden.
But if you're running like 10,20,100 files, bouncing back and forth can add
significant time to the overall process.