Auto fill table based on the data from another workbook

[Biona]

Hi all,

I am trying to figure out the way to automatically fill the table in workbook "book2" based on the data from workbook "book1". Is it possible to auto fill the table by using macro? I have thousand of data that I need to fill in the table, and it will spend a lot of times. I really appreciate for your help..

I had attached the file to show what I want to do. Thanks.

[Biona]

I can use VLookUp method to fill up the table by manually. It is possible to use macro to slove the problem?