VBA Code for Excel Sheet

I'm looking for someone experienced with VBA code, I want to basically compile data from multiple worksheets within an excel workbook to sheet to show outstanding tasks. New worksheets will be added and this data must also be compiled as the worksheets are added into the workbook. We must also be able to delete worksheets too and thus the compiled data

I have attached the excel file. The Outstanding Task worksheet has text detailing what we are trying to achieve