Formula to copy text from specific cell to new cell on new tab

[jtmbell]

I have a large Excel document with several tabs. I am needing a formula that copies a specific cell to the new tab if the account information is listed.

Sheet 1 (yesterdays report)
Account number is in column B
Account notes are in column EB

Sheet 2 (todays report)
Account number is in column B
Account notes will be in column EB

I want a formula for sheet 2 so that if there are already notes for a specific account on sheet 1, it will carry those notes to that account on Sheet 2.

I have tried countifs and vlookup but I cannot get it to pull the notes, it only adds an X indicating there is information in that cell. All help is appreciated! Thank you!