i also have two more macros to insert in the userform but i just don't know how to do it or where to put them
for example once the sheets are selected i need to copy and paste the data to a new sheet that the user has the choice to name it whatever he likes.
Sub freeplay_report()
Sheet56.Select
Range("A1").CurrentRegion.Select
Selection.Copy
Sheet57.Select
Range("A" & Rows.Count).End(xlUp).Select
ActiveCell.Offset(3, 0).Select
ActiveSheet.Paste
Sheet54.Select
Range("A1").CurrentRegion.Select
Selection.Copy
Sheet57.Select
Range("A" & Rows.Count).End(xlUp).Select
ActiveCell.Offset(3, 0).Select
ActiveSheet.Paste
Sheet53.Select
Range("A1").CurrentRegion.Select
Selection.Copy
Sheet57.Select
Range("A" & Rows.Count).End(xlUp).Select
ActiveCell.Offset(3, 0).Select
ActiveSheet.Paste
'this are the sheets i need to work with
'i am going to copy and from each one and paste it to a new sheet
'Sheet56.Select
'Sheet54.Select
'Sheet53.Select
'now i need to create the loop
End Sub
and the second macro I need to insert to the userform is a sumif , again I don't know where to put it or how to insert it
Sub sumifseveral()
'
' sumifseveral Macro
'
'
Range("E4").Select
ActiveCell.FormulaR1C1 = _
"=SUMIF('ancma 4-7-2019'!R3C2:R173C2,ancapril!RC9,'ancma 4-7-2019'!R3C5:R173C5)+SUMIF('ancma 4-14-2019'!R3C2:R188C2,ancapril!RC9,'ancma 4-14-2019'!R3C5:R188C5)+SUMIF('ancma 4-21-2019'!R3C2:R165C2,ancapril!RC9,'ancma 4-21-2019'!R3C5:R165C5)"
Range("E5").Select
End Sub