Copying specific data and save into new file

Hi,

I'm very new to programming and have a task at work which is very repetitive and time consuming and I'm sure there must be a way to automate it.

On the attached are a list of example fund manager trades. I copy each group of trades belonging to a fund manager, paste this data into a template spreadsheet already open and save as eg Aberdeen Unit Trust Managers Limited Transactions.xls.
I dont know where to start really...any help would be much appreciated?
Cheers