Build Expense Sheet in Excel 2007

Need to build an Expense Tracking sheet in Excel. Ultimately, the sheet will interface with Quickbooks. In order to create a user friendly tool, I need to have each of the following lists (pivot table data from quickooks), autocomplete/limit choices while typing in a given cell. There will be four columns: Vendor, Customer, Service Item, Class. Each column is it own pivot table. From what I can tell [login to view URL] links basically spells out how I want it to work with some actual coding. But I dont know VB. I have attached a sample files so that you may understand the basic structure I am working with.