I maintain a status sheet of hundreds of assets (listed in the rows). The
columns contain various fields that capture what state each asset is in.
This gives me a row by column status table. The status is updated daily, so
changes to fields are made by overwriting the old field value with the new.
Is it possible to track the changes to these fields over time? Currently, I
make updates to the table and save it as a different name to preserve the old
state. Frequently, I have to go open an old status sheet to see what state
an asset was in at a previous time. I would like to have all data, old and
current on one sheet.

Is there an easy way to acheive this? I envision a 3 dimensional matrix in
which the 3rd dimension represents time - this would give me a asset by field
by time status sheet.

I use Excel 2003 ver 11.x