How to show summay sheet with large volume of data

I have a billing system that shows the customers name, amount owed, outstanding amount.

I have this on sheet 1. On sheet 2 I want to show the summary that is easy to read. I have attached an example.

I can do this for individuals, the problem I have is I have over 3000 customers and I wondered if there is a way of showing the information quicker and going into each individual and doing =sheet1!B1.

I hope this describes the issue. If not please let me know.

Thank you in advance.