Function Help

A

atxcomputers

Hi,

Ive had some really good help so far thanks to this site and
hopefully someone can piont me in direction for this one.

I have 8 worksheets and Im trying to get a specific reference from A1

The specific reference is listed on the other 7 pages in column A

I want it to tell me the reference it found, if its possibly

Example
sheet1
A1 = abc toy car 789DIN19
sheet2 = Toy Cars
A67= 789DIN1977

This is the closest reference on all of my worksheets

i want C1 to = 789DIN1977


Any help
 
Top