In a worksheet, sheet-1 is a master sheet which have about 15,000 rows in the
following columns
A1(Unique id)
A2 Names of persons
A3 Address
A4 Amount for the year 2006
A5 Amount for the year 2007
A6 Amount for the year 2008 (Blank / no date)

In sheet-2 I have 22,500 rows and have following columns
A1 (Unique id)
A2 Names of person
A3 Address
A4 Amount for the year 2008

In sheet-3 I have 12,000 rows and have following columns
A1 (Unique id)
A2 Names of person
A3 Address
A4 Amount for the year 2008

In sheet-4 I have 2,500 rows and have following columns
A1 (Unique id)
A2 Names of person
A3 Address
A4 Amount for the year 2008


I require automatic updation of all the rows of column A6 (from 01 to
15,000) of sheet 1 from column A4 of sheet-2, sheet-3 and sheet-4 with the
help of Unique ID.

Please help to filter the data as I urgently needs this macro or formula to
save my time to search each & every data.