help please

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

Yes it's possible what you

Yes it's possible what you need to do is create a invoice format first then apply vlookups or formula to fetch your data against your invoice number and then use vba coding to run a loop to print invoice of number with the help of vba.