Copy and Paste Cell Values between Workbooks on Separate File paths

Hello Your 'Excel'lencies!

Please help with this. I have a macro that can copy and paste values from one sheet to another on the same workbook with a control button as shown below:

Please Login or Register  to view this content.

However, I need assistance with a Macro that can replicate values on a range of cells on a worksheet for an open active workbook located on a directory based on corresponding entries or changes on an array of cells from another workbook located on another directory at the click of an embedded control button

For instance, in the attached file,I would want any updates or changes done on Cell "A4","B4", "C4",.. to "AO4" of 'Billing' sheet to be replicated on corresponding cells "H13", "I13", "J13",.. to "AV13" repectively of the 'Main' sheet at the click of Active X control button in a case whereby the 'Billing' sheet is on a separate workbook (from the workbook with Main sheet) on a different directory

Same for 'App' Sheet: to replcate update or changes on Cells "A4","B4", "C4",.. to "AO4" to apply changes on corresponding cells "H6","I6", "J6",.. to "AV6" accordingly

Note:
Main sheet is located at

HTML Code: 

Billing sheet located at

HTML Code: 

and App sheet located at

HTML Code: 

I would really appreciate.
Thank you in advance!

Thank you JLGWhiz, however, there are formula in the "App sheet" and I tried the PasteSpecial as shown below but getting error "Unable to get the PasteSpecial property of the range class".

Please what could be wrong?

Please Login or Register  to view this content.

Thank you so much JLGWhiz and Winon! I was to able to achieve the result with the code below:

Please Login or Register  to view this content.

Appreciate the help!