Excel 2007 : auto fill help

I have a list of employees with ids and department infomation on a spreadsheet and would like to have the information auto fill on another sheet when the id is filled in. Is this possible?

I have the employees listed on sheet named "database" as follows:
name id center department (columns a,b,c,d)

Then on the next sheet named "may"(I have one for each month) I would like the information to populate if an id is entered that is on the list in the sheet database. (same order different columns (e,f,g,h))

Can anyone help??

That worked great, but its only pulling the information from row 2 on the database spread sheet instead of the row of info that the ID is on...

I just dont get it....

Thanks for the script SClai, that worked, mostly... the name column is always right, but the Center and department column are almost random. Either the code will get all three feilds right or just the name and center, sometimes just the name.

Ive taken to continuing on and just manually checking the information on the database page, but this is tedious and would love to have the confidence that the information is generated correctly without having to double check it.

I appreciate any assistance/tips... Thanks in advance!

Oh YAY! that false addition worked perfect! all set guys Thanks alot!!!