Here is a macro that will copy the following cells from the Daily Control Report worksheet:
to the next available row on the Monthly Overview worksheet.
Assuming that there is header data in row 5 of the Monthly Overview worksheet, then new data will be pasted, starting on row 6.
The macro is attached to a button on the Monthly Overview worksheet.
When a new Daily Control Report has been pasted into the Daily Control Report worksheet, clicking the button will put the summary data onto the next line of the Monthly Overview worksheet.
To add the button do this:
From the Ribbon select Developer (If it's not visible go to the Office Button, select Excel options at the bottom and select the Popular tab and check the 'Show Developer tab in the Ribbon' box)
In Developer - Controls select Insert and choose the button icon.
Draw the button on the worksheet
In the 'Assign Macro' dialog box select 'New'
In the code window that opens enter this:
Private Sub Button1_Click()
Dim rngMonthEnd As Range
Dim varSource As Variant
Dim n As Integer
'put source addresses into a variant array
'this list of cells can be changed without
'changing the rest of the code
varSource = Array("C4", "B2", "G2", "J2", "F3", "B3", "E5", "A11", "D14", _
"B11", "D11", "C11", "E11", "K11", "K13", "B6", "D6", "G14", _
"I13", "E17", "F17", "C18", "C20", "E14", "F14")
'find row after end of monthly overview data
Set rngMonthEnd = Worksheets("Monthly Overview") _
.Range("A" & CStr(Application.Rows.Count)).End(xlUp).Offset(1, 0)
'copy each cell in array to cells in columns starting at A on next row
For n = 0 To UBound(varSource)
Worksheets("Monthly Overview").Range(rngMonthEnd.Address).Offset(0, n) _
.Value = Worksheets("Daily Control Report").Range(varSource(n)).Value
Note that Sub Button1_Click() and End sub will already be present, so don't duplicate them. Option explicit goes before Sub Button1_Click().
Click Save from the Visual Basic Menu.
Alt+f11 takes you back to the main Excel window.
Right click the button and Edit the name to something meaningful
As changes made by Macros cannot be undone with the Undo button, test this macro on a copy of your data. Always make a backup of your Workbook before running this macro. This code has only been tested on sample data, and it has not been tested in your environment, so test it on copies of your data to ensure that it works 'as expected'
After selecting any cell, the new command button should now respond to a click and run the macro.
I hope that this is what you were looking for.
If not please provide additional details.
If the macro does not work 'as expected' please post what happens when you run it and what is not correct.