VBA To Add Rows Or Columns If Information Not Exist

I have a spreadsheet that contains overtime information for employees. Basically, it has a list of names in column A, and a list of projects in the first row, similar to this:

Name
100323
100887
100987
100987
Sum

[Code]....

At the top of the page I've inserted a section similar to this:

Name
Project Number
# Of Hours

SMITH, John
100883
5

Where the name and project number are drop down data validation lists containing all of the project numbers and employees at our facility, and the # of hours section is just a manual entry.

I require a macro that, upon clicking a button, will verify that the name is in the list and insert a row if there isn't as well as verify the project is in the row and insert a column it isn't.. then it will add the number of hours i specified in the box. It would also be nice if the list of names would sort alphabetically and the project numbers would sort numerically from left to right after any additions. As well as clear the selections and # of hours I entered in the second table shown above once everything has been entered in to the main (first) table.

I'm pretty new to creating my own macros (even though im an engineer.. )