Is there a way to make a Data Entry Form by using the worksheet as the form?

Hi,

I need to make a data entry form that actually uses the current worksheet as the form and then commits data to a seperate sheet, the drawback would be that I would need to edit data using the form and also I need to be able to use the same name for different entries for different appointments (this would require the form to be able to create seperate entries for the same client name).

I have never used VBA code I am aware that this would need to be used to create any data transfer from one sheet to another.

Any ideas?

Cheers

JD