Concatenate String, and Sheet and Cell Reference in VBA

I am trying to create a referenced formula in VBA with combined strings, cell, and sheet references.