Copy in range of cells and referencing values in copied range

[michaelmmoses]

This may be answered somewhere else, but I cannot find a post that does it. Basically, I want to copy a range of cells that has formulas in them to a new worksheet in the same workbook but have the pasted range automatically include formulas that reference the values in the copied range without having to manually enter them. The purpose is to ensure that, as values change in the copied range, they are updated in the pasted range. Is there a less labor-intensive way to do this than entering simple formulas in the pasted range? There probably is VBA code that could accomplish this, but I am hoping there is a way that does not include macros.