VBA macro to find specific cells, copy the content and paste to ranges

Don't work with Excel much but have been asked to format an Excel report.

Users get an Excel report like the one attached. It has a blank column A. They get a summary of the user and their total and then it reports for the next rep, etc, etc. users want to filter various columns. They are having an issue tying the reps name to a particular row. They can see what ones belong to the rep but when filtered the rows get out of order and they can't also filter by the name. They want to tie the name to every row the rep that owns the record. The only way I know of doing this is to look for the cell that has the first name (Total for Smith,Bill: 10
), copy it, move up one row over to column A and paste the name onto every record above until they hit say a blank cell (case # let's say). Then it needs to look for the next rep name and do the same thing. Any ideas? Thank you