Combine Rows of Data on Common Value

Hello everyone,

I have 2 huge spreadsheets with multiple columns of data that I would like to combine if they have the same account number.

For example

On Sheet 1

Column A is Account number Column B is address

On Sheet 2 is Account number Column B is revenue

I would like combine the rows of data based on account number.

So

I would have on one sheet Account Number, Address, and Revenue for the assigned account number on one row of data.