Based on the PAID column in BOOKS-ACC ,
1. Amount has to be adjusted in GTB,WB,NB,STAT
Ex: Suppose AMOUNT is 3770 then and PAID is 3000 then
it has to be distributed in GTB,WB,NB,STAT accordingly.

2. Based on the Date column in BOOKS-ACC,
Automatically,
SUMMARY sheet columns has to be summed up.

KIndly help me solving the problem.

Sample-Sheet.xlsx