sheet 1 needs to be daily consolidation of others

sheet one is the total (consolidation) for the day
sheets 2-99 are the individual customers. Each line on them: date, invoice number, basic rate, calculated surcharges, calculated discounts, shipping, invoice total


I wish to make it so that automatically the line from the customer sheet also inserts onto the consolidation page so that each day there will appear the total of that day's transactions for all customers. (Not every customer sheet will have an invoice for any given day)

thank you!

thank you for replying but your example only gives the one lump total, not the entire line for each customer. I need the consolidation sheet to show all charges for each customer so the one sheet is all the boss needs to see for an overview of what occurred that day, rather than having to thumb through 99 sheets to find out.

Client 1 date1 $A $B $C $D $E $F $G
Client 2 date1 $A $B $C $D $E $F $G
Client 6 date1 $A $B $C $D $E $F $G
Client 19 date1 $A $B $C $D $E $F $G
Client 42 date1 $A $B $C $D $E $F $G
Total for date1 $A $B $C $D $E $F $G

Client 6 date2 $A $B $C $D $E $F $G
Client 10 date2 $A $B $C $D $E $F $G
Client 54 date2 $A $B $C $D $E $F $G
Client 55 date2 $A $B $C $D $E $F $G
Client 93 date2 $A $B $C $D $E $F $G
Total for date2 $A $B $C $D $E $F $G

etc

I hope this better explains what I need