Merging Multiple Worksheets Into One...

I have searched with no luck, but here we go...

I have a workbooks with two worksheets. Both worksheets have a unique identifier column - Column A In worksheet 3, I need to have the contents of worksheet A and worksheet B combined. There are no duplicates in the unique identifiers column. Simple right?

Attached is a sample of the workbook.

Thanks in advance.

Hi mrmwangi and welcome to the forum.

If you put the following formula on sheet 1 cell E2 and pull it down and to the right, if will do what you want. That is combine both tables into a single table.
=VLOOKUP(Data1!$A2,Data2!$A$2:$H$5,COLUMNS(Data1!$D1:E1),FALSE)

See attached.