I have 2 workbooks/worksheets with one column that is unique (the primary
key) that is shared across the 2 workbooks, but each workbook has some
additional columns that the other does not have and are arranged in different
order. I want to combine the data in one worksheet such that all of the data
one each individual primary key row is combined into one worksheet.

For eg:
Workbook 1:
Columns: Primary key, imaging value, test result

Workbook 2:
Columns: Primary key (with the same values as workbook 1 but in a different
order (2, 4, 1, 38, etc), stress value, coefficient

I want a worksheet that shows the imaging value, test result, stress value,
and coefficient for each individual primary key (1, 2, 3, 38, etc).

Thanks!