Merge two workbooks Excel 2016

Hi I have two workbooks that both contain a column (column A headed Part no.) with a list of part numbers and numerous other columns of different information in each workbook, I am wanting to combine the two workbooks so that for every part no. that matches from each workbooks the information is appended, added a pic to better explain what i'm trying to achieve shows 3 workbooks with the last being what I want to create from the first two. any help much appreciated.