How to i merge worksheets in together through a common cell value in each worksheet

I have data in one worksheet that has the same id number in column A as different data in another worksheet, how do i combine or merge or link the 2 worksheets so i have all the columns of data from both worksheets in one worksheets linked by the common id number.

i have tried lookups it doesn't work for me

the ids are located in a2:a30000 in each sheet , the other columns are different and not all ids are present in each worksheet.

I believe this can be done with software called ActiveData, but i don't want to pay $250 for this.
Anyone know how i can do this?

Thanks