What I usually do is automatically copy the entire row when the last data is entered and paste it to the first available row on the MF sheet. I don't know how your sheets are made up, but you can try the following if you like the above idea:
Place this code in the first 3 sheets:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Columns("F:F"), Target) Is Nothing Then Exit Sub
Rows(Target.Row).Copy Sheets("MF").Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
Once you implemented the code and make a change to column F, the entire row will be copied to the MF sheet. Change "F:F" to the column where you enter the last data of the row.