https://www.dropbox.com/s/f83y17dedajbsz8/example.xls

There is an example workbook for what I want to do.

There is the first sheet, which I basically use to put copy the data from the other sheets onto sheet 1 (Main). The other sheets have all the data I am concerned with, and each row has a unique code (e.g. Fruit01, Pie01, Juice01 etc.).

What I want to be able to do is TYPE in the unique code into any cell on column D of sheet 1. If the code typed matches any of the existing codes in any of the sheets available, then that entire row will be copied onto sheet 1.

Being able to copy the £ sign isn't important, as I forgot that I won't actually have any special symbols on my actual worksheet I'm trying to get this on.

Hope that makes sense.