Excel VBA...please help me..??

[clara]

Dear experts,

I really need your help please...In Excel, I have Sheet1 (as a BOOK), Sheet2 (as a PEN) and Sheet3 (as a Payment). When we open this file, it will show the pop up first which contain as follow: Select type: BOOK or PEN, then enter the code number..For instance, if I choose BOOK, then it will fill all information from another SHEET (Sheet1 / Book) such as Code, Description and Price in the Sheet3 (Payment)....Has anyone knows how to do that please?

To make it clear, I put an attachment for this.

I really appreciate for your helps...thanks

Clara