I looking for something I could utilize that would compare two excel
spreadsheets. It would need to compare across all cells and note any
changes. There will be text and numbers contained within the cells.

I've seen some stuff posted on here, but it compares (I.E cell A1 to
cell A1). The excel spreadsheets I'll be reviewing will have adds,
updates and deletes. So it needs to compare based on a unique
identifier (probably name in first column) and then note if there are
any changes. Also, note if the data between the two excel
spreadsheets is new or deleted data.

This is far from elegant, but it might be useful.

You could save both as csv files, open one in MS-Word, and use Word's
featu
Tools Compare and merge documents