That's because your code isn't behind your buttons. For example, the button on sheet C1 is called CommandButton1 but the code is behind a button called inputsheet (which doesn't seem to exist). Either rename your button or move the code.

Dion