Copy entire row(s) from multiple sheets to a master sheet in the same wookbook

[Wedgy253]

I have multiple expense sheets (one for each community managed), I need to copy the expense details from these sheets to a master expense sheet. Each expense sheet totals monthly and YTD, and I don't need those rows copied. Thank you in advance for any help!

 

[Michael M]

This will consolidate the date from each sheet to the "Master" sheet

Sub MM1()
Dim r As Long, lr1 As Long, lr2 As Long, ws As Worksheet
lr1 = Sheets("Master").Range("A" & Rows.Count).End(xlUp).Row
    For Each ws In Worksheets
        If ws.Name <> "Master" Then
        lr2 = ws.Range("A" & Rows.Count).End(xlUp).Row
            For r = 1 To lr2
                    ws.Rows(r).Copy Sheets("Master").Range("A" & lr1 + 1)
                    lr2 = ws.Range("A" & Rows.Count).End(xlUp).Row
                lr1 = Sheets("Master").Range("A" & Rows.Count).End(xlUp).Row
            Next r
        End If
    Next ws
End Sub

You will need to give us more info on how / what defines the monthtly / YTD rows !!