Collection data from source sheet

VLOOKUP formulas will do this for you.

On Sheet 1, in B2 put the following formula:

=VLOOKUP([@NAME],Table134,2,FALSE)

Then the same in C2 and D2, but change the number before ",FALSE" to 3 and 4 respectively.

Because you have your sheet 1 as a table, the formulas should automatically copy down to all other rows.

The principle is the same regardless of your table sizes.

The VLOOKUP formula is constructed as...

The field you want to find in your unique values. In this case this is [@NAME] which is the column in your target table (Table13)
The range which holds your unique values. In this case this is your table on Sheet 2 (Table 134)
The column number containing the value you want to appear in your target table, counting across from the left
FALSE is used to ensure that there is an EXACT match to the NAME.

So you need to find which columns have your source data and set the formula to find the NAME and count across to that column.

Having your source and target values in tables makes this simpler as the rows will just expand as you add more records so you won't need to change the formula as more data is added.

If a record in your target does not exist in your source table, you will see a #N/A value in your target table. If you want this to appear as something other than an error you can modify your formula to something like this:

IFERROR(VLOOKUP([@NAME],Table134,2,FALSE),"Not Found")

You can replace the "Not found" with any text or a number (leave out the quote marks if you want a number)

Hope that helps, but ask more questions if you get stuck.