You have information on sheet2 that would be useful if it were in sheet1 e.g. Agent Name (see Sheet2 A8), also Origin (Sheet2 B4) how does this information get input on this sheet? I'm assuming manually!? So why not have this information also on Sheet1 maybe in columns A and B and then you could use Vlookup or Index & Match etc. based on this criteria. I am a little confused??