I am having difficulty with autofilling cells in different sheets. I have unit ID numbers, which i have to copy to differnt forms on different sheets. but i would like the ID number to change based on which cell or check box i select.

the user will move the check and the cells in the different sheets would copy the name assigend with the X.

check box x
Unit ID A-1 B-1 C-1 X-5