I have a workbook with several sheets, one for each client. Each sheet shows
"Client Name", "Transaction Date", "Transaction Amount", "Balance". Now, I
wish to create a sheet with a "Summary" showing the "Client Name", "Balance"
for each sheet, and the "Summary" is based on "Today's Date".

How can I pick up the last balance of each sheet?