I have multiple vendors, payment team maintains payment data, then accounting team maintains their data in accounting software. Now, I want to create a template which includes both these 2 sources i.e. Accounting and payment teams into one single sheet by vendor.

Here is an example-
Pyament team data consists - Vendor #, vendor name, date of payment, invoice #, PO# and amount paid. This has all vendors in a single worksheet
Account team data consists- similar data as well as some additional data such as when the payment was actually due, posted and cleared. This has all vendors in a single worksheet

Someone may think why I need 2 sources on one single file. It is very hard to track which team is efficiently recording all data, hence we created an individual vendor wise worksheets that should include both the sources so we can compare if one team is missing data or not.