Split table, based on two criteria, into separate workbooks

Hi all,

I would like to be able to automate the process of splitting up a table and saving these new tables to separate workbooks. I've been asked to do this for my manager at work, and it is a spreadsheet to track employee commissions. All commissions are being stored in the one sheet, for all months and agents, but at the end of each month we need to separate the commissions for each agent for the relevant month.

I've attached an example spreadsheet that has three columns (the actual spreadsheet records more data): A1, Organisation name; B1, Agent; and C1 Month. The required criteria is the month I need and, if possible, I'd like to have a choice of selecting a specific Agent or selecting all. For example: get the commissions for all Agents for May; or commissions for Agent Tom for June (this would be a bonus, but not essential). The code would need to split the table according to the desired criteria and then save each Agent's commissions into a new workbook with the file name format of "Agent - Month" (i.e. "Tom - May").

I use Excel 2010, but I'd like it to be compatible with 2007 as well.

I'd like to thank anyone who attempts to help me with this in advance.... Thanks.