How can I automate this series of actions in excel?

I’m pretty Excel savvy, but have hit the edge of my abilities with this problem. I have a series of actions that I need to automate and am not sure how. I’m running a Mac, but have Parallels and a windows virtual machine, so I can use either. I basically need to take every 12 line chunk of an excel sheet (they’re monthly data for hundreds of different sites) and save each chunk (site) into a separate file. The bigger problem is that these files need to be titled (could just be numerical order, could be named for a cell, etc). Can I do this using VBA? What about Applescript? Any ideas?