djapigo, how's the title now? Better?.........

I've looked at VLOOKUP but the cell in sheet 1, as I indicated, will be changed manually. Therefore, I cannot put a formula in sheet 1 cell A1.