Can that macro function be revised to specify the cell in the Previous Sheet that is to be used in the new function?

For Example; in cell R1 of the new sheet I would like to perform an operation using the value contained in A1 of the previous sheet. How do I modify the macro to accomplish that?