I made a "form" up with pull down menus and named columns. I'm hoping to use
this as a form system for customers. My problem is that when I copy the
orignal worksheet and put it in a worksheet in the same workbook the formulas
keep refering back to the copied worksheet.

How do I make the formulas only refer to the worksheet that the data is in?
I would like to be able to just keep one orignal and then copy and rename
that worksheet for every new customer.

Thanks