VBA to copy function acording to cell Value

Hello people

I have the following problem.

I have one sheet with a table that contains in each row a code and the 8 next cells (to the right) have formulas in it.
I have about 20 rows, each with a code like "9x-wa", "SHBJ", "3dx2", etc

In another worksheet this formulas need to be aplied according to the Code.
So I have a cell in each row with these same codes, now I need to copy the formulas from the Sheet 1 to Sheet 2.

I am pretty enw to VBA, so I was following a (copy, paste) logic, like:
Copy code (9x-wa) from Sheet 2, Find "9x-wa" in Sheet 1, Copy the 8 cells to the right. Go back to sheet 2 and paste acording to row.....

But I figured this is a pretty ugly way aint it? Is there any VBA funcion to make it easier?

Thanks in advance.

Ups, Sorry, didnt see I could attach a file

Basicly the yellow cells should be filled out with the formulas from the Formula sheet using the according function to the code.

Thanks

that was just an example file. actualy I have about 20 dirrerent formulas and codes.