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!