Link two dynamic workbooks with multiple tabs

Help Excel gurus! I need your help on a project I'm working on. I hope someone can give me some advice as to how to tackle it.

There are two teams in my department, and each is assigned to maintain their respective work book and I'm looking to link them in order to save some time.

Team A - Responsible for receiving Invoices (Bills) and entering them in an excel spreadsheet when received and update when bill is paid. Only one tab in this workbook.

Row A - Name of company billing us
Row B - Invoice #
Row C - Invoice Amount
Row D - Once Bill is paid the check amount is entered here
Row E - Balance Due (Row C - Row D = Row E)

Team B - Is Responsible for maintaining a list of all checks issued. All of the checks issued to pay the bills received by Team A are entered here plus
other checks to pay a variety of different stuff. On this workbook a new tab is created every month. One tab per month. Since we need to follow accounting
rules and record the check NOT on the month it was paid, but on the month the service was provided. for example I might be paying a bill in the month of November
for services that were provided in September, so I would need to enter this check in the September Tab.

Row A - Name of company check is paid to
Row B - Invoice #
Row C - Amount Requested to be paid
Row D - Reason for payment
Row E - Date of check issued
Row F - Amount paid
Row G - Check #

Here is what I want to do.
I want to link both of these workbooks so that when Team B fills out the information of the check issued this will automatically update the Workbook of Team A so that
the balance is zeroed out.

He is my challenge. Workbook of Team B has multiple tabs so I can't just do a simple Vlookup and also every month a new tab is created (very dynamic workbook).
TO add to this in Team B's worksheets have to be in alphabetical order, which means that rows are inserted everyday. for example if I paid yesterday to A and C, I enter company A in Row1 and Company C in row 2 but today I received invoice from Company B so in order for them to be alphabetically I would need to insert a
row between Row1 and Row2. So if I had links to this workbook they wold not update when the new row is added.

Can someone help me please. Please let me know if I'm clear on what I'm asking.