Aggregating Total Invoices for Duplicated Customer Orders in different sheets

describes Non-LINQ / LINQ Approaches for your case