Formula to copy data based on the text in the cell

Hello,

I need to find out how to do this (and would be grateful if anyone could help me with this):

I have a tab (1) in Excel with ten thousands of rows for ten thousands of different projects containing, among others, the ID number, the title, and the description of different projects (in three different columns).

In another tab (2), I have a selection of these projects (reduced to a +/- 500 projects) for which I only have the ID number in a column.

Now, as you can guess, what I would need, is a formula (or anything else) to automatically copy of the title and description of the project from tab (1) to the selected projects in tab (2).

Something like: if the ID number is 123 in tab (2), then find this ID number 123 in tab (1) and copy the data that is the other cells of the row of tab (1), to the cells that are in tab (2).

It seems easy said like that but I just can't find a way to do it...

Thanks in advance for your help!