VBA for Excel Workbook

I am wanting some VBA to automate a few simple processes within an Excel Workbook. In addition we need someone with a creative eye to make the Worksheets look professional. Functionality required; The Workbook will contain 2 worksheets. The first worksheet contains about 10 data entry fields. Once the data is entered, I want an action button to post the data to the second worksheet as a transaction with an ID number. Each transaction sent will be placed in rows on the second sheet. The first sheet also requires a look-up facility so the transactions can be retrieved. The look-up facility should allow me to either type in the transaction number or click a drop down menu to search for it. Once the transaction is retrieved some of the data may need to be updated and then re-posted under the same ID number. Once the data is posted through to the second worksheet, some basic calculations will be made. So the second worksheet needs to be able to cater to making these calculations once the transaction is posted. I have attached the template. Lastly, the worksheets needs a nicely styled interface so it looks professional. I will supply an accurate template without any of the VBA or creative aspects. Cheers