Creating A Dynamic Budget

[JediMaster]

To help me explain please view upload,

The table in sheet1 (SETTINGS) different customers have different set amount of payment structures ranging from 7 days to 28 days and also the option to pay monthly on set day of the week and be holiday consious (weekend bank holidays etc)

The above would be applied to invoices also so once all the data has been collected the final outcome would be like sheet3 (IN & OUT) with a sub total at the end of each inputed day a sub total remaining

the formulas in sheet 2 work out all the dates from the information given in the SETTING sheet

the problem being is that once I start moving the tables about so that they are sorted in oldest to newest all the dates are then incorrect like example in Sheet4