I have multiple worksheets within 1 workbook. Each worksheet has the exact
layout. I enter multiple vendor invoices on a weekly basis on each worksheet
and would like to get a total of each vendor for the year. These totals
would come various entries from some or all worksheets.