VBA to save cell data to table and retrieve it later

[JamesDandy]

Is there someone that can assist with some VBA code that will save data from various cells across multiple worksheets into a table that I can later retrieve and replace any of the cells that have been changed?

Ideally I'd like to be able to copy this set of cells multiple times, collecting various versions of these cell values, with the ability to retrieve any one of the multiple saved states and replace them back to their selected state.

I have asked this on another Excel forum in a slightly different way and provided an example to work from but I have received no answers from them: https://www.excelforum.com/excel-pr...-ability-to-recover-any-data.html#post4756998