How to populate workbook table from user input in another workbook?

[ascalise]

Hey everybody,

I'm trying to keep a master list of product data that will automatically populate based on user input.

The way things are currently set up, a user fills out a worksheet with product data (serial number, calibration information, customer, etc.) and a VBA coded button formats the name of the form by date and serial number, and sends it to another folder, retaining the original template. We then have to manually enter all of this information again into a second workbook (master list) of all products and data.

Is there a way to have the information input cells automatically get sent to the master? I would like to retain the structure of the original worksheet as much as possible.

Thanks in advance,

Will do my best to answer all questions.

Software:
Office 2010
W7 x64

 

[ascalise]

Found how to do it if anyone was interested:

How to Transfer Data from One Excel Workbook to Another Automatically | Excel VBA Training Videos

Does anyone know a way to do it in the background? (Without opening the second workbook)