Share Data between to Excel Workbooks and Sheets

I was wondering if someone can tell me if the following is possible, or it it's just wishful thinking on my end

I have two workbooks. One is a check register with multiple sheets for different accounts, and one is a payment submission form. The check register is more or less to track a series of different budgets.

What I'm doing now is filling out the payment submission form, and essentially reentering the data into check register. I was wondering if there is a way to simplify this and some how GET certain data from the payment request into the proper sheet. The tricky part of this would by dynamically adding the entries to the check register under the correct account code. I suppose there would be some type of IF statement... saying if account number xxx123 enter the data into sheet 2, if it's account yyy123 enter data into sheet 3, etc...

Not sure if this makes any sense or not, but any help, direction, or even if it's possible would be much appreciated.

probably putting if statements in diff. sheets( if meets certain criteria)
for the workbooks sharing you can use paste links.

a sample workbook will be much appreciated so others like me can cope up with your problem.