Insert into different tables on different sheets depending on entry criteria

I recently created an excel computer inventory spreadsheet for my job and I want to streamline it so it's easier for users to work with. Right now it's 7 sheets and on each sheet there's about 4 tables. The 7 sheets are for each department and the tables on each sheet are the offices within that particular department. What I'm looking for is to add a user form so it will be a single point of entry for all departments.

The fields that would need to be entered are:

Hostname
Property #
Department
Office
User/Location
Model
Service Tag
MAC (LAN)
MAC (WLAN)
Operating System
Processor
RAM
Purchase Date
Warranty End Date

Take the above fields for instance, all would be text boxes, except the Department and Office fields would be Combo Boxes (Drop Down Lists). When the user selects the Department and Office they're in it will automatically add all the entered information from the textboxes into the correct table.

Are there any tutorials I can follow that are very close to what I'm wanting or could someone help me out? I'm not great at VBA at all, really just have programming background in C based applications.

bump - any ideas?