Saving worksheet Renditions Within single Workbook based on List Value

My goal is to save numerous renditions of a worksheet based on the value of a single cell, used as the identifier of the worksheet.

Ideally, these renditions are all accessible through a single workbook, that when a different 'identifier' is chosen, the values previously saved under that rendition will automatically populate the cells they correspond with.

If it were a simply reference I would just use an IF() statement, but I'm trying to adapt it to the entire worksheet.

Any help or hints would be greatly appreciated.