The problem with this is that you haven't indicated what a 'record' is and where it is stored. In order to automate this the macro would need to be able to determine which employees related to they 'record' associated with that e-mail message. Certainly that information is not available from the message subjects you have described.

If the macro has that information then what's the point of forwarding the message to various people if you merely want a copy of the message in the appropriate folder? Do the recipients associated with the 'record' actually require the e-mail of is it just a filing exercise?