I have this master sheet saved in my computer (C:\Users\damien\Desktop\Master\Master Template - Copy.xlsm) and want to copy the range from a workbook i have opened from the internet (not saved anywhere)
The document is called (DC %2D Warehouse Slot Code QTY OH By WHSE.csv) tab (DC %2D Warehouse Slot Code QTY)
I want to copy (B2:F25) from (DC %2D Warehouse Slot Code QTY OH By WHSE.csv) tab (DC %2D Warehouse Slot Code QTY) to (C:\Users\damien\Desktop\Master\Master Template - Copy.xlsm) tab (strat SOH)
another problem comes in because it is a temp file when i open it again to get an update the new name is (DC %2D Warehouse Slot Code QTY OH By WHSE-1.csv) but same tab (DC %2D Warehouse Slot Code QTY)
Is there a way to do this

Thank you