Continuous/Automatic Data Integration From Two Tables into One

first of all thanks for giving me your time...
as for the questions-

• I want to integrate Purchase & Bank Transactions(Payment part/dr part) / Sales & Bank Transactions(receipt part/cr part)... if it will be a problem feel free to separate them into receipt and payment tables...
• Sales, Purchase, Bank Transactions(the first three sheets) will be entered manually and then will be combined in groups of sales+reciept(bank transactions) & purchase+payments(bank transactions)
• the Sales, Purchase, Bank Transactions sheets will be updated everyday...
• I have improved the attachment file

feel free to ask if there is anything else