HI, I am trying to make a table using other worksheets as references.
I am very new to excel and doing this for company. I am having difficulty using the VBA cuz this is my first time ever to use VBA. Here's what I need to make code for.

-Find matching chemical element from main worksheet in my reference worksheet ( "C" for 1st run)
-Copy the values on the same column of matching chemical element and paste them onto my main worksheet table
-Go to Next chemical element and do the same (now it will be "Mn")
-Run the loop until all the values on my main worksheet is filled (until "B". Average row at the bottom and last 3 columns already have codes)

Above will be the first loop. And I need another loop that is for the next reference worksheet. So basically, I will have "x" amount of reference worksheets containing different set of values. I have to create "x" amount of tables on my main worksheet and fill up the tables using all those reference worksheets.
Does anybody know how to make VBA code for this???!
I attached picture below. top left picture is the reference worksheet (usually i have more than 2 of those tables, with their cell locations different for each file). The top right is my main worksheet. Bottom left is the folder that I contain all my reference files and main worksheet.!