I am trying to figure out how to use a worksheet as a form to capture data that is stored in another worksheet in the same workbook.

I know the excel template wizard does this already but the data is captured in a separate workbook. Is there a way to modify this?

Thanks for any assistance.