vlookup codes - multiple sheets

I use excel 2003 and sometimes 2010 so my solutions have to run on both.

Im getting n/a errors when i use vlookup to search another sheet for values.

I put my data in a sheet called 'data' and then search postcodes which are stored in 3 other sheets named pcode1, pcode2, pcode3.

I use the vlookup to attach the following to each postcode: Constituency Name, Ward Name, Westminster Name, Council Area Name, SP Region.

An example would be:
=VLOOKUP(B2,pcode1!$A$2:$I$65001,5,FALSE)

where B2 is the postcode
pcode1 is the first sheet with 65000 postcodes
column 5 has the constituency name, col 6 the ward name, col 7 the ward name, col 8 westminster name and so on.

Ive attached an example sheet.

How do i write a vlookup macro to search across all three sheets (pcode1, pcode2, pcode3), infilling the 5 fields next to each postcode (and most importantly while avoiding the dreaded n/a erorrs)?