Copying Cell(s) from Source Workbook to Separate Closed Target Workbook in Background with VBA

[VBAsic]

Hello,

I am very new to VBA and desperately need help!

I am trying to set up a master (source) Excel workbook that pulls from/pushes data in approximately 12 other workbooks. Whoever is using the source workbook needs to be able to:
1. Write a date into two specific cells (E10 and G10) in a sheet named "Stats" within the source workbook
2. Push a command button*
3. Replace the values of two specific target cells (E11 and G11) in a sheet named "Master" in all of the 12 target workbooks (they all have a sheet named "Master") simultaneously with the dates entered into E10 and G10 of the "Stats" sheet within the source workbook.

This needs to (appear to) happen in the background, as the 12 target workbooks will not be open and can not appear open when the command is complete. The only workbook that can remain open at the end of the command is the original source workbook.


*It is not essential that this is accomplished by pushing a button (it could just happen automatically), however I just think that is one way to accomplish the action.

Thank you very much for any and all help!!!