VBA to copy range from one workbook and paste to another open workbook

Hello,

I've been searching the forums and haven't found just what I need. I should mention that I'm not very skilled in VBA, but have lots of experience tweaking other people’s code for my own use.

I have a Global (source) workbook which contains data on the "Checks" sheet (data range is A5:V). I need to be able to copy that range and paste into multiple other Regional (destination) workbooks in range A2:V. I will have three regional workbooks. The "Checks" sheet in the Regional files will be hidden. I'd like the copy/paste to occur whenever the Regional workbooks are opened. I'd be fine using a macro button, if that is easier.

I’d like the entire contents of the “Checks” range to be pasted over any existing data in the Regional files’ Checks tab (basically refreshing the data each time).

When users open the Regional files, the Global file may/may not already be open. Each file is in the .xlsm format with a password. I’ve attached sample GlobalSource and RegionalDestination workbooks (password is set to “password”).

Here is my process

1. User updates the Checks tab in the GlobalSource file. Saves file. May/may not close file.
2. User opens RegionalDestination file. Checks tab is refreshed (should match the data in the Global file)

Any help would be greatly appreciated!

Do you want the RegionalDestination files to be opened and then updated, 1 by 1 just after the Global file is saved?

Maybe you can have the Regional files closed at the time of the update?

If that is the only (or best) way, then I'd be fine having a button in the Global file to trigger the updates to the Regional files. Then I could be certain that all the regional files are closed prior to doing the update.

Its not the only way as there could be other ways which i am not aware of. Its just one of the easier ways to work with, with minimum issues.