Macro for extracting the information from one worksheet to other

Macro for extracting information from one worksheet to other:

I have attached two sheets book1,book2

Book1: Having the source information
Book2: Extract the value from the book1 & put in the proper place.
Book 2 - Red marked column to be created & filled automatically [L Value]

By clicking the command button from book1,data to be filled automatically populated in book2.
Please guide me for the same