Hey y'all -
Basically, I'm using Excel2007 and trying to create spreadsheet for clients to submit payroll hours etc on. I have one sheet with columns: Name, hourly rate, salary, bonus, etc. with Rows being the Employee. My goal is to have my client fill out a separate sheet with employee info requiring certain fields before entering on the summary sheet with that pay period's hours.

Any suggestions how to create the summary sheet? Would like the client to be able to select the employee from a Data Validation list type of thing, to then enter their hours etc. The way i started it is by having a summary sheet of all employees (columns being name, addresss, SSN, and all the other info they enter in on the individual info sheet. Hope it makes sense... I'm sure there are more options to accomplish this. ANY insight or suggestions are greatly appreciated. Not opposed to different methods either. Thanks in advance, and hope I posted in correct section.

I'm not super comfortable with VBasic coding, but am very computer literate and learning code stuff by trial and error.