reference part of cell address from button and part of another cell

I have a button located in cell D9, when I click the button I want it to find the value in C9 which would open a worksheet by referencing the value in C9 as the worksheet name. I want the macro to find the row address of the button and combine it with column "C" because I have buttons all the way down Column C and I dont want to make a macro for each one. I am working with this code but its not working:

Please Login or Register  to view this content.

thanks, that works but could you add some code for on error for when the sheet is not found?

Thanks, that code it still has an error that says byref argument type mismatch so I made this instead:

Please Login or Register  to view this content.

Yes, that works great, thanks!