How about something like this:
* A 'control' sheet in the master workbook that lets you specify the source and target (if different from the master) workbooks, and any other parameters that might be relevant.
* Buttons (or something similar) that let you run the transfer.
* If required, some kind of output indicator that lets you know whether the transfer was successful, and any relevant metrics or output.
Make sense?