I have 10 sheets which contain identical tables for entering a chemical
process.

I use user forms for data entry, and would like to set up a single form for
use on each sheet.

I want to use a single form that can be activated on each sheet and will
enter data on the active sheet.

I dont want to have to recreate an individual user form for each of the
identical sheets but rather use a single form that will enter data for the
specific sheet the userform is activated.

Can anyone help with relevant the code to do this?

Thanks,

Roger