Create a vba macro that will be able to create 4 additional sheets on a workbook. Rename those sheets to prefefined names. Copy some some some fixed rows to each sheet. Then copy some rows based on criteria. Those rows will be distributed to the new sheets according to the criteria. At the end of each sheet some sums will be done.