how to update data from one datasheet to a master sheet, automatically

I had another post but it was shut down, i wasn't aware of all of the rules for posting and wasn't to familiar with excel.

I was told to use vlookup and after that i read up on it but i just can't get the hang of it as far as the complexity of my situation.

I am NOT looking to expand my knowledge of excel, i am just looking for a solution to a particular problem for my small business. rather i have to pay someone in the end or i have to pay for software to do this, it does not matter. actually i would prefer software if anyone knows of any to perform the functions i need.

in the 2 attached files, i have a work sheet i named "mysheet" and a work sheet i named "sheettoupdatefrom" {sheet to update from}.

basically i have a list of a few hundred items, within these in one of the columns, i need to have a unique column or a master column to where the information in the individual cells on this column will match up to the 2cd data sheet and auto update info in the row of my data sheet.

the new updated sheets comes out at least once a week. the columns are always the same but the rows change, meaning i cannot link the sheets to update by row number.

i need my unique name, in the example file i uploaded i named the unique file names by sports. in the example, i need to take the unique name of football, match it up to the new data sheet to update from and update the info, in the example, the updated info i would need would be the "number" column and the "color" column.

if this is confusing, in a summary, i need this:

auto update information according to unique name in a column, this will update certain info in the unique names same row.


I tried my best to explain this, if i did anything wrong please advice me via personal message instead of replies. i will update what i need to do from there.