Extract SU Number from one sheet to another.

Dear Friends

I herewith attached a sample sheet;
in this sheet name Maxicare I need
Su No to other sheet name Mechcare.

Thanks in advance for help in this
problem.

I've added a helper column in data sheet, and used Index and match to get the SU in another sheet.
We can do it using VBA code as well.

Sir,

I change Profile Details,
SU = Service Utility Number

Dear MY0987,
Thanks for your quick reply.
Answer is not reflecting
cell in sheet Mech care J6.

The Answer only reflecting
cell Mech care J7.

I need more help in this regards.

Try this..