Macro to copy paste without having all the source books opened

Hello Kioskea users. I hope you're all doing great. Today I have a concern that I'm not able to figure out. Any help will be really appreciated.

I'm creating a macro in excel to copy and paste the values from one workbook into another one. So far it works like a charm but it only works when I have all the files open. How can I make the macro get the values without having the other files opened? So far I have this:

Sub PastefromDashboard()
'
' test Macro
'

'Copy Values from Source
Windows("Dashboard.xlsm").Activate
Range("F151:L160").Select
Selection.Copy

Windows("Destination").Activate
Range("D3").Select
Selection.PasteSpecial Paste:=xlPasteAllUsingSourceTheme, Operation:=xlNone _
, SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

End Sub

I appreciate your time and any help that can provide me with.

Thanks,
Fabian