Macro To Transfer Subtotals From Worksheet Into Another

I'm having trouble with this macro I'm trying to write. I have a worksheet that's subtotaled like this:

Cash 100,000
Land 65,000
Equipment 104,000
Kroger Foods Total 269,000

Cash 200,000
Buildings 25,000
Equipment 25,000
Prepaid Rent 50,000
Whole Foods Total 300,000

The data is obviously just an example, but that's how it's set up (a subtotaled worksheet with three columns). My issue is that I need to write a macro to copy these numbers in column 2 (ex. land - $65,000) and paste them in a cell in another worksheet that finds the particular cell to paste it in based off column 1 and column 2.

For instance:

Cash Equipment Land Prepaid Rent
Whole Foods
Kroger

Essentially, I'm trying to find a way to copy the totals in column three and paste them into a cell in a certain row (based on column 1), and column (based on column 2). I'm pretty lost, and I just need some guidance as to how to tackle this. So far my code sets column 1 and 2 as strings and sets the columns in the second worksheet to these strings, and from there I'm lost