Copy non-contiguous cells and varying data types

Yes, attached is the key worksheet. The range I'm trying to capture is identified as those cells with the yellowish fill and the purple fill. I'd like to take a snapshot of those cells and copy them to an area to the right, out of sight, or if possible, hold them in memory using the "Copy Worksheet Button"