Normal Invoice System in excel

Hi Sir/Madam

Currently i try find a excel system which can help me do on below for my home business, i've try to search online for alternative solution but fail, hopefully here can get me an answer,

Basically i need

-searchable of the product name which link to sheet"Product List" / from the tutorial from internet is using drop down list but i not sure how to apply in every sheet.

-the price in every sheet will refer back to sheet"product list" as well as the customer category . because diff customer we will gv them diff price. Should be using Vlookup function ?

-the invoice number will accumulate count and insert to sheet "invoice" with the customer name and amount receive
after user press check out button

-When user press check out button , the existing sheet will clear all the number , description and other, and export one excel sheet to //drive D or E /folder name( follow by customer name) / invoice number follow by date
example (D:/MR808/INV001_270613)

Sorry for bad english and thanks in advance for help!
steve

cross post link to - http://www.mrexcel.com/forum/excel-q...tem-excel.html