Issue to extract data without Vlookup

I have trouble extracting data from a huge file. Until now I was using Vlookup but of course it only takes the first number it finds.

I need to be able to read data in each columns = X,Y,W,Z for the corresponding id.

Normally there is maximum duplicates but it happens that I have the same ID multiple times in the data tab.

Thus, I need to have a sum of all data in a column that corresponds to a specific ID.

In the image below, I need to pull out information for ID A.

I simplified the file. But normally I have hundreds of different ID's and they are all mixed up.

Thank you for your help I hope I was clear enough.

I can't wait for your answers !