match data between two or more colums to complete data from diferent sources into one .

Hello i need some advice, i need to complete a master list from diferent sources, but i need to "add" data to my main column from other secondary columns, i want something like if this colum have this exact data then get added to the main colum, so i can complete my firts data colum from many sources, without manually searching and copy paste values, i already used Vlookup, but it stoped working, and i cant get INDEX-MATCH to work properly, i could use some advices and if posible some examples, my main colum is in tab "pesos consolidados"
and colums are "referencia" and "peso", i want to complete my data from the other secondary colums, thats why i used Vlookup, but for some reason i cant make it work again, al my #NA where from previous VLOOKUP, but i was trying to make several VLOOKUP, to finally fill blank spaces i mean like just parsing everything from all the colums, not in the same as the function, but now is not working, and i am in need of some help, because there is too many data to do it manually.