I have to raise a large number of invoices every month, which I currently do mainly manually at the moment. I am looking for a way to auto populate from 1 sheet to the next.

So
On sheet 1 I have all the data - name / date / cost, this will feature a persons name multiple times. I then have a separate sheet for each individual that receives an invoice. at the moment I sort the data by name and copy and paste into each sheet. I am looking for something that will say if the name e.g Sue appears add date and price to the sheet called sue.

Is this possible?

Thanks in advance