How to get details or break up of balances of many customers at once. Sample file attached

Hi,

Please refer to the sample file attached with this post.

I have prepared a Working sheet named "Working_Customer A" from "Basic sheet for Customer A" sheet. This is done for a single customer. I would like to prepare a similar sheet for many customers. This is to be done on daily basis. There are more than 300 of such customers. So it is not practically possible to prepare it for all the 300 customers on daily basis. I have attached a sample data having data of 5 customer in "Sheet 2". Also refer "Closing Balance" sheet which contains closing balances of various customers.

Basically it is the break up of the amount to be received from customer. It shows that against which invoices the total amount is due. It uses FIFO method, i.e. the payment or credit entries are first adjusted against the oldest invoices & the balance due is always for the latest invoices.

The problem I am facing here is that the data of all the customers comes in a single sheet.

Would be grateful if you could solve it.