Dear anyone that can help. i am new to functions and formulas in excel, and only really use it in a basic way.

what i have is the following, two sheets with huge amounts of data on cells.

A1 through to O1 has information on a piece of equipment.
A2 through to O2 is the same piece of equipment with different serial number.
A3 through to O3 is a different piece of gear

A1 is AMP1001, A2 is Amp1002 A3 is AMP2001

on another sheet i have more information that i wish to put on the first sheet

A1 is AMP1 i need the infomration from D1 through to M1 copied to the first sheet to P1 through to z1
of course A2 needs the same information from the first cells.

A3 needs to copy the information from second sheet A2.

is there a formula that can lookup A1 on the first sheet, and if the information on the second sheet has part of the same text (AMP1 or AMP2) will copy to the first sheet?

i hope this makes sense.

thanks in advance for your help, it is very much appreciated.