Macro / VBA that makes list's

Attached is a releaseable copy of my alpha roster. what i am shooting for is a way to generate list's on a seperate worksheet based on my current needs. for example if i want a list of all my 30-60-90 day losses then it will generate that, or a platoon alpha roster instead of the entire company for platoon sergeants, or overdue-30-60-90 ncoers. i think that all of these reports can be done simply by referencing a desired cell reference, but as a vba/macro amatuer i am not positive. im looking at keeping the formating of the reports the same including the headers and footers, only changing the report name, hopefully referencing the maco/vba name as the title. when it comes to platoon level alpha rosters, i would like for the included charts to be included in the report as well.