Google sheets AppScript help

I am working on making an improvement to my invoice reconciliation process. I would like to automate certain tasks in my Google Sheets using AppScript. This includes removing duplicates when pasting data, creating new sheets based on the pasted data, renaming the sheets based on the data and ensuring each row has been accounted for.