VBA using 'sumif' referencing previous sheet

[jmhopper]

Hello ~ I'm trying to write a VBA statement to do a SUMIF calculation on previous worksheet's columns. If I entered it into a cell it would look like:

=SUMIF('prevsheetname'!$X:$X,$K:$K,'prevsheetname'!$D:$D)

I'm new at VBA and need help with the syntax for the apostrophes and ampersand symbols, please! Any help will be appreciated, thank you.

 

[jmthompson]

Syntax is not my strong suit, so my usual cheat is to record a macro while I enter the formula in a cell.

 

[jmhopper]

I would do that, except it hardcodes the sheetname into the formula. I need to make this more generic since the previous sheetname will be changing.