that's awesome way to do it !! but sadly I have to stick to 1 sheet according to their policy.If you can do not keep any space between the vendors, just make a database sheetwith the following columns
SupCode currency Sup Name INV No. INV Date InvoAmountO Pay AmountO Diff
the difference column, cells should have inv amt-paid amt.
Now at the end of this table say in column Z, make a list of supplier name ( If needed make the column Sup name to be data validated for list from this table ) so say in cell Z2 you have hertz and cell Z3 you have the entry oriental trading co, for the column containing supplier name you will be able to select these names, increase selection as much as you want .
In Column AA 2 put this formula =SUMIF(F:F,Z2,G:G) In this change F to the column name of your supplier name, and change G to the column name of your difference THEN YOU WILL GET THE TOTAL DIFFERENCE AMOUNT FOR EACH VENDOR
Not only that in Column AB2 put this formula =SUMIF(F:F,Z2,G:G) In this change F to the column name of your supplier name, and change G to the column name of your Inv. amt, THEN YOU WILL GET THE TOTAL INVOICE AMOUNT FOR EACH VENDOR