Need VBA code to copy and paste as values

[Panama1182]

Need VBA code to copy and paste as values from a specific range A1:AE36 in a worksheet named "Matrix DSR" and workbook named ""Daily Sales Report Master Update File - CQ_v2" to a specific range A1:AE36 in a worksheet named "Matrix" and workbook named "BMH Daily Sales Report thru 08-21-19 run date 08-22-19 Compared to Budget and PY"

The file/workbook name will be updated everyday with new dates in the file name.

For example, the next day it will be called "BMH Daily Sales Report thru 08-22-19 run date 08-23-19 Compared to Budget and PY"

Please help or if you have any other suggestions please let me know. I am trying to automate the "copy and paste as values" process to increase speed.

Thank you,

Panama1182