Merge Matching Records

Hi all,

I would really appreciate your input, direction and help, and I thank you in advance.

What I would like to do
I would like to merge/add the data of multiple sheets of matching records to that matching row. I.e. if an ID number in sheet B matches an ID number in sheet A, the data/content of that matching row must be copied and placed after the last column.

Example: Also see attached images - Sheet A + Sheet B = Result

Sheet A

ID Number Name Surname
123 Dan White

Sheet B

ID Number Address1 Address2
123 Brooklyn NY

Result of merge

ID Number Name Surname Address1 Address2
123 Dan White Brooklyn NY

Thanks!