Help!!!

I came accross several post pertaining to autofiltering and extracting
to different sheets, However, What I need to do is this:

Having a File with 6 lin Header
(Company Name, Project Name, Document Name, Date, then Column Labels)

I have the rep number on Column "A" starting at "A7"

I have to compile the records of each rep to one file (not sheet) then
get the total for each sheet at the bottom.

Any help will be greatly appreciated.

Niegel