Need help with copy and paste VBA code

I have the following code which I got to work, copying a range from one workbook to another.

Sub ValuePaste()

    Workbooks("04.10.17 SHELBY.xlsx").Worksheets("Summary $500-$10K").Range("B8:F21").Copy
    Workbooks("Consolidated_template_new1_WA.xlsx").Worksheets("Invoice Threshold $500-$10K").Range("B8:F21").PasteSpecial Paste:=xlPasteValues

End Sub

the problem I have is that I have to copy the same range from file "A (Shelby). ex:04.11.17 Shelby.xlsx, 04.12.17 Shelby.xlsx, etc) into file "B" Consolidated into a new range.

is there a way to copy the Range from file "A" (B8;F21) to the new desire Range?

File A Is a file that I have to open from the cloud (not on my local drive) but one file is open I got the code to work. just need to know how to copy same range to my consolidated file.

Let me know if you need sample of file.

thank you