Formula / Macro Help

Hi,

Can anyone help me?

Can i use a Formula or do i need a macro?

I want to Search text (cell A1) and i wish it to search in column A on 5 other worksheets for that reference. If it then finds a match on one of the sheets i want it to tell me on sheet1 in B1 that its in worksheet 4 for example

ie

Search Field - - sheet1 A1 = Toy Car

Information held - - sheet4 A335 = Toy Car

Answer - - sheet1 B1 = Sheet4

Can this be done??

Any help appreciated

Regards

Craig