I have a form that I've created in Excel (because Word forms are too unruly
and difficult to manage) but I need to be able to merge data from another
sheet that's in a table format into the form.

I'm envisioning something like a command button that will enter in single
rows of data into specified cells in the form each time the button is clicked.

So for example, the user clicks CommandButton1 which then looks at Sheet2
and enters data from A1:A15 into various cells on Sheet1, prints Sheet1 and
then moves on to look at B1:B15 from Sheet2 until it gets to a blank row and
then stops.

I know some of you masters out there can help with this! Thanks all!