VBA code create new sheets and name them

Hi Guys
Need help again

Trying to bo work book where

Sheet1:
Is complete list of names ( put name "C3" and it generates Invoice No"B3")

Sheet2
Generic sheet2 where the others would be based on

I need VBA code which would:

Automaticly create New Sheets Based on input of the name in row C on sheet1 besed on sheet2
Than name the sheet with the Invoice No.
Than transfer the Invoice No "B3" and name "C3" onto new sheet
and than transfer the total from new sheet on to Sheet1

I have attached dummy file how it should look like

Thanks very much for your kind help