sorting rows

I have an excel sheet that imports info from a fantasy football website. It imports one table that has the monthly scores on one sheet, and i have one sheet for every month . It imports another table that has the total score. The website already sorts these tables, the first table in order of descending monhly score and the second table the same. This means that when they import the players are not in the same order in the two tables. I then have a table that shows
Player / team name / weekly score / monthly score/ total score

The first 4 colums feed from the info from the first impoted table but the fifth column feeds from the second imported table. is there a way I can order the fifth column lets say where the names match place the total score in this row.

dont quite follow ,what do you want, where? got an example

if xxx= yyy then zzz in which cell and exactly from where ;sheet names cell refs would be a help