Hard for me to explain when I don't know what your workbook, worksheets or data look like, nor what you want the macro to do.

Do you have any code that already works on a sheet ... you just wish to initiate it by pressing a button on another sheet?

Full qualified would look something like:

sText = Sheets("Sheet2").Range("A1").Value

Regards, TMS