Reconcile two spreadsheets

I have one spreadsheet that contains asset values (called Assets) and a second spreadsheet that has the finance details and balance owing for those assets (called “commitment schedule”). Both spreadsheets have the identifier numbers for the assets - I need the data from the “Commitment Schedule Spreadsheet” for “Finance” and “Balance” copied into the new columns I have created in the Assets Spreadsheet. Note that the “Commitment Schedule” spreadsheet has the data on two tabs, but the “Assets” has only one. Both these tabs need to be collated into the Assets spreadsheet. There are approximately 100 lines of data.