Creating Macro to capture history

most versions of excel have a "track changes" option. First you have to share the workbook (in 2010, go to REVIEW\SHARE). Then there should be an option to list changes in a new sheet.

Thanks Mallycat

Firstly, I want just a restricted range of thirty or so cells to be compared and tracked in a spread sheet of about thirty sheets. Secondly, I want any dummy to be able to see the changes without having to work too hard. I am a dummy myself, so I should know that this wouldn't work (Can I dummy assert that this won't work? did I just create a paradox? I dunno, coz dummies like me don't know words that big).

Anyway - Can the macro thingy be created, or is it just wishful thinking?