Macro to create individual reports off of a Master Workbook

I need a way to take my compiled data and divvy it out to new, smaller workbooks for individual agents.
Any ideas?

Here is what I have so far:

Formula:

Please Login or Register  to view this content.

I tried reverse-engineering a macro that took individual workbooks and compiled them into a master workbook. I don't think I have covered all the holes though. Should I even do it this way or just start from a totally different direction?
Sorry, there is a lot of fluff in there that is just me recording actions.