"court" wrote:

I want to create a button on a main worksheet to transfer data and save it
into another worksheet each time the main worksheet is used/filled out for
inventory purposes. In other words, once my employee fills out the
worksheet, they can push the "completed" button, for instance, and it will
transfer into another worksheet.

Is the second worksheet the same on each occasion, or is it new every time?