VBA copy/paste from variable workbook to static workbook

[dkovall]

I'm certain this question has been answered numerous times, but I haven't found an answer that fits my particular needs.
I'm trying to copy several cells from 4 different sheets of a variable workbook named by date. It would be saved as "17-Aug-18" today for example.
Then, I'd like to paste the copied data into the next available row of a static worksheet called "Production Master Report".
I haven't done any coding in years, and can't remember the little I did know.
Any help would be GEATLY appreciated!

 

[mumps]

Is the variable workbook already open or does the macro have to open it?

 

[dkovall]

variable workbook open. macro would open the static workbook

thank you

 

[mumps]

What is the full name of the static workbook including the extension (xls, xlsx, xlsm)? What is the name of the sheet in this workbook where you want the data to be copied? What is the full path of the folder where the static workbook is saved? What are the names of the 4 sheets and the cells on each sheet that you want to copy from the variable workbook?

 

[dkovall]

X:\CMC\MINE\MINEPLAN\Development Projects\2018 Dev.Projects\Luce Phase E - Stage 2\9.Reports\1. Daily Production Report\ProductionReport Master.xlsm

Sheet1

X:\CMC\MINE\MINEPLAN\Development Projects\2018 Dev.Projects\Luce Phase E - Stage 2\9.Reports\1. Daily Production Report\


Haul Drills, Fuel, Personnel

Haul - F34-F37, H4-H36, L-34-L36, N34
Drills - E30-K30
Fuel - F10-H10, F21-H21, F45-H45, F60-H60, F74-H74
Personnel - C10-D18, F10-G18, I10-J18

 

[dkovall]

Also, I'd like to use a command button called "Export" to activate the macro

 

[mumps]

You say

I'd like to paste the copied data into the next available row

Please clarify how you want the copied ranges to be pasted. For example, F34:F37 is a vertical range, F10:H10 is a horizontal range and C10:D18 is a multi row/multi column range. If you can post a screen shot of the end result after pasting, that would give me a better idea of what it should look like.

 

[dkovall]

I understand the copy ranges are strange, but I would like to paste all copied data in a single row from left to right
Maybe I have to copy each cell individually, I do not know

 

[mumps]

Do you want to copy the data from all 4 four sheets to a single row or do you want to copy the data from each sheet to a separate row?

 

[dkovall]

All data from all sheets would go in the same row, starting with data from 'haul', then 'drill', etc